Creating New Products in BigCommerce from LightSpeed Retail POS by Kosmos eSync

Now that you have connected your LightSpeed Retail POS to Bigcommerce, below you’ll find the criteria to create new products and how to 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 (Send Standard Items)

See list of Actions used to create products below. file file file

Note: Each Action will also need to be configured

First create all your categories in BigCommerce by adding the Category Actions into its own Task. Do not turn on the Task schedule, since all categories are sent up on each RUN of the task. All new products that are added in Bigcommece will then be associated with the matching LightSpeed category.

file

Criteria to Create a New Product in BigCommerce from LightSpeed

file

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

  • Item SKU has been updated with new product_time_stamp in POS.
  • Item has SKU in LightSpeed
  • Item has a Weight in LightSpeed (not required)
  • Item marked in LightSpeed for List Item on Sale on Web Store with ‘webstore’ tag.
  • Item is Active in LightSpeed
  • Item has a Product Name in LightSpeed
  • Item has a Category in LightSpeed

1. Create Matrix Products (Send Matrix Item Action)

  • Parent Item SKU has been updated with new database time stamp in Revel.
  • All children Items have a Lightspeed SKU
  • All Items 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 in LightSpeed
  • Item has ‘Online’ Price Value (zero or higher) in LightSpeed
  • Item has a Category in LightSpeed
  • Product Description in LightSpeed (not required)

See below list of Actions needed to Create a New Matrix Item and Updates.

file

Note to test creating a new matrix product simply update the Parent item and verify it has a ‘webstore’ tag. For example just change the cost or price of the parent, hit save and all child items will create after you run your eSync Task.

file

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

List Item on Webstore - LightSpeed Web Store Module - It’s Free!

Contact support via Chat and inquire about getting the Free webstore module for 3rd party integrations.

file Click for more information on LightSpeed List Item on Webstore. Click for more information on LightSpeed List Item on Webstore.

2. Create Matrix Products (Send Matrix Action)

  • Item was recently updated with new database time stamp in LightSpeed.
  • Item has SKU in LightSpeed
  • Item has a Weight in Lightspeed (zero or higher)
  • Item marked in LightSpeed for List Item on Sale on Web Store
  • 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
  • Parent Product Description in LightSpeed (not required)

The Unique Identifier is the product SKU that ties the two systems together.

Troubleshooting

  1. I can’t create Matrix products.

    1. To sync a new Matrix item you need to make sure you have the LightSpeed ‘Legacy Web Store’ plug-in installed and have a tag with lowercase ‘webstore’ added to every sku in the matrix.
    2. Special characters in the parent name may be problematic. Hyphens and dashes are fine.
    3. Weights are required, does your product have a weight?
    4. Creating Matrix products takes more time than simple products. Wait 15 to 30 minutes and hit refresh in the cart after. The eSync Green bar once complete has just sent the product information to BigCommerce. BigCommerce now needs to un-package and process the data to create a new Matrix.
    5. A sku is required, so verify that you have a sku.
    6. Try updating the product_time_stamp and hit RUN again after and view your Activity Logs next.
    7. The Category must exist first before the product will create.
  2. Not all Matrix sku’s are being created.

    1. Be patient, the product may be still building. If after 15 to 30 minutes and you hit refresh, try updating your time stamp for that sku and RUN esync again.
    2. Verify each child or variant item has an assigned sku’s. You cannot create a product without a sku.
    3. All sku variants or child sku’s will need the ‘webstore’ tag to sync.

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.

file

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

See video example on Bulk Migration of Items and Inventory from your POS to your Shopping Cart

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

Was this article helpful? Votes: 0
Create Products BigCommerce | LightSpeed BigCommerce | Creating Products LightSpeed | Update Inventory Bigcommerce | Update Inventory Lightspeed |