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.

After you have configured your Actions, only add one Action into each Task. There are instances when you can add two Actions or more into a Task, when instructed for orders. In this current release, if the first Action has no data to process the second and third Actions in the same Task will then be ignored.

First you’ll need to create your categories in BigCommerce to match LightSpeed.

Criteria to Create a New Product in BigCommerce from LightSpeed

1. Create Simple Products (Send Standard Action)

  • Item SKU has been updated with new database time stamp in Revel.
  • Lightspeed SKU
  • Item has a Weight in LightSpeed
  • Item marked in LightSpeed for List Item on Sale on Web Store
  • Item is Active in LightSpeed
  • Item has a Product Name in LightSpeed
  • Item has Inventory Value (zero or higher) in Revel
  • Item has Price Value (zero or higher) in Revel
  • Item has a Category in LightSpeed
  • Product Description in LightSpeed (not required)

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)

Syncing existing Matrix Items requires options and option sets to match if you’d like to also update price See creating BigCommerce options and option sets from LightSpeed POS.

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

Criteria to Sync Inventory with Existing Products Run your inventory only Actions to update inventory to BigCommerce 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 has a new time stamp in LightSpeed POS.
  • Item has a sku in LightSpeed matches BigCommerce
  • 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)

  • Item has a new time stamp in LightSpeed
  • Item has a sku in LightSpeed matches BigCommerce
  • Item is Active in Lightspeed
  • Item marked in LightSpeed for List Item on Sale on Web Store
  • Matrix Parent Name must match POS and BigCommerce.

Troubleshooting

  1. My Matrix Inventory isn’t syncing why?

    1. To sync Matrix inventory only, the Parent names both have to match the POS and BigCommerce.
    2. Look out for spaces in the Matrix Parent name. A trailing space before or after the name will also cause problems with syncing.
    3. A sku is required so verify that you have a sku.
  2. I can’t create Matrix products.

    1. Look for special characters in the parent name. Hyphens and dashes are fine.
    2. Weights are required, does your product have a weight?
    3. 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.
    4. A sku is required, so verify that you have a sku.
    5. Try updating the time stamp and hit RUN again after and view your Activity Logs next.
    6. You may also need to delete your options and option sets if the product was not created at all. Wait 15 to 30 minutes before doing so. See above reference on how options and option sets are created.
  3. 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 item has an assigned sku’s. You cannot create a product without a sku.
    3. Weights are required so make sure all sku’s have a weight.

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.

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 |