How to integrate your Lightspeed Retail POS with Shopify
Now that you have connected LightSpeed Retail to Shopify, you’ll find the criteria for creating new products and updating existing products for inventory and price below.
Note trials are limited to 48 hours or two days of product updates. With paid subscriptions you can go back and look for products added or inventory updates over a year or longer. With paid subscriptions, you can simply update your Action Dates via the calendar to go back a year plus if needed.
# Test with a single Action first
Note the Unique Identifier to sync and create products in Shopify is the Product Name or title. If you change the product name, then another duplicate product will be created.
The Shopify SKU is also needed to match items to your POS. So, in this case the System SKU, UPC, Custom SKU or MFG SKU from LightSpeed needs to match the Shopify SKU field. So, both the product name and the Shopify SKU need to match your POS.
Criteria to Create a New Product & Sync Existing Products By default, with Shopify and the new locations feature, all new products are created with inventory = 1. See Inventory Only Actions for instructions on how to update inventory from the POS.
1. Create Simple Products & Update Prices (Send Standard Action).
- The item was marked in LightSpeed for List Item on Sale on Web Store with a ‘webstore’ tag.
- Item SKU has been updated with the new product_time_stamp in POS.
- Item has a LightSpeed SKU
- Item is Active in LightSpeed
- Item has a Product Name in LightSpeed
- Item has Inventory Value (Zero or higher) in LightSpeed
- Item has ‘Online’ Price Value (Zero or higher) in LightSpeed
- Item MSRP is Higher than the Online price
- Item has a Category in LightSpeed
- Item has a Product Description in LightSpeed (not required)
- Item has a Weight in LightSpeed (not required)
List Item on Webstore – LightSpeed Web Store Module – It’s Free!
Contact LightSpeed support via Chat and inquire about getting the Free webstore module for 3rd party integrations.
2. Create Matrix Products & Update Prices (Send Matrix Action).
- Item was recently updated with new product_time_stamp in LightSpeed.
- Item has a LightSpeed SKU
- The item was marked in LightSpeed for List Item on Sale on Web Store with a ‘webstore’ tag.
- Item is Active in LightSpeed
- Item has a Parent Product Name & Child products in LightSpeed
- Item has Inventory Value (Zero or higher) in LightSpeed
- Item has Price Value (Zero or higher) in LightSpeed
- Item has a Category in LightSpeed
- Item has a Product Description in LightSpeed (not required)
- Item has a Weight (not required)
Criteria to Sync Inventory with Existing Products: Run your inventory only Actions to update inventory to Shopify after a new product has been created. You will also need to update your inventory timestamp after.
3. Sync inventory only Standard Products Action (Send Inventory Levels Standard Action).
- Item names match LightSpeed and Shopify.
- Item has a new inventory time stamp in LightSpeed POS.
- Item has a SKU in LightSpeed
- Item is Active in LightSpeed
- The item was marked in LightSpeed for the List Item on Sale on Web Store.
4. Sync inventory only Matrix Products Action. (Send Inventory Levels Matrix Action)
- Matrix Parent Name must match LightSpeed and Shopify.
- Item has a new inventory time stamp in LightSpeed POS.
- Item has a sku in LightSpeed
- Item is Active in LightSpeed
- The item was marked in LightSpeed for the List Item on Sale on Web Store.
Note: The time stamp for creating products in LightSpeed is different from the time stamp to update inventory only in LightSpeed. So, running your Send Products Action after a sale in your POS will not update inventory. You will need to RUN your Update Inventory Levels Action in this case.
Simply view your TASK Activity logs and Upload the Full log to a Support Ticket for further assistance.
See the article on – Kosmos activity log and status codes
See the article ‘How to trigger point of sale updates for an integration.’
See the video example of a Bulk Migration of Items and Inventory from your POS to your Shopping Cart and the following article, Kosmos Bulk Migrations.
If you’d like to purchase a support package, you can do so here.
If you have further questions, please post a ticket in our Help Desk.