LightSpeed Shopify - Creating New Products in Shopify by Kosmos eSync

Now that you have connected LightSpeed Retail to Shopify, below you’ll find the criteria to create new products and update existing products for inventory and price.

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 new locations feature all new products are created with inventory = 1. See inventory Only Actions on how to update inventory from the POS.

1. Create Simple Products & Update Price (Send Standard Action).

• Item marked in LightSpeed for List Item on Sale on Web Store with ‘webstore’ tag.
• Item SKU has been updated with 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 Online price
• Item has a Category in LightSpeed
• Item has a Product Description in LightSpeed (not required)
• Item has a Weight in LightSpeed (not requiered)

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.

Click for more information on LightSpeed List Item on Webstore.

2. Create Matrix Products & Update Price (Send Matrix Action).

• Item was recently updated with new product_time_stamp in LightSpeed.
• Item has a LightSpeed SKU
• Item marked in LightSpeed for List Item on Sale on Web Store with ‘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)

See article on ‘How to trigger point of sale updates, for an integration.’

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 time stamp 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
• Item marked in LightSpeed for 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.
• • Example Lightspeed: http://prntscr.com/kgsa6p
• Item has a new inventory time stamp in LightSpeed POS.
• Item has a sku in LightSpeed
• Item is Active in LightSpeed
• Item marked in LightSpeed for 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.

Also, see the following help article for list of Activit Log messages.

If you’d like to purchase a 5 hour support package, you can do so here.

If you have further questions, please post a ticket in our Help Desk