Revel & BigCommerce - Creating New Products and Updating Existing Products (Inventory & Price)

Now that you have connected your Revel iPad 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 your Revel POS.

Criteria to Create a New Product in BigCommerce from Revel

1. Create Simple Simple Products (Send Standard Action)

  • Item SKU has been updated with new database time stamp in Revel.
  • Revel SKU or Barcode
  • Item has a Weight in Revel
  • Item marked in for 3rd Party in Revel
  • Item is Active in Revel
  • Item has a Product Name in Revel
  • Item has Inventory Value (Zero or higher) in Revel
  • Item has Price Value (Zero or higher) in Revel
  • Item has a Category in Revel
  • Product Description in Revel (not required)

Revel - Display on online and 3rd party file

Revel Weights file

2. Create Matrix Products (Send Matrix Action)

  • Item was recently updated with new database time stamp in Revel.
  • Item has SKU or Barcode in Revel
  • Item has a Weight in Revel
  • Item marked in for 3rd Party in Revel
  • Item is Active in Revel
  • Item has a Parent Product Name & Child Products in Revel
  • Item has Inventory Value (Zero or higher) in Revel
  • Item has Price Value (Zero or higher) in Revel
  • Item has a Category in Revel
  • Product Description in Revel (not required)

Syncing existing Matrix Items requires options and option sets to match. See creating BigCommerce options and option sets from LightSpeed POS. 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 for new inventory updates.

3. Sync inventory only Standard Products Action. (Send Inventory Levels Standard Action)

  • Item has a new time stamp in Revel POS.
  • Item has a SKU or Barcode
  • Item is Active
  • Item marked for 3rd Party in Revel
  • Item names match both Revel and BigCommerce

4. Sync inventory only Matrix Products Action. (Send Inventory Levels Matrix Action)

  • Item has a new time stamp in Revel POS.
  • Item has a sku
  • Item is Active
  • Item marked in Revel for 3rd Party
  • Matrix Parent Name must match POS and BigCommerce.
    • Example Revel Parent Name: http://prntscr.com/iiy8zt Note: The time stamp for creating products in Revel is different from the time stamp to update inventory in Revel.

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.

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
Inventory | Price | Update Price | Update Inventory | Creating Item | Creating Product | Revel Bigcommerce |