Sync Inventory Updates and Create Products from Clover POS in WooCommerce by Kosmos eSync

Now that you have connected your Clover to Woocommerce below you’ll see the criteria to create a new product, update an existing product 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

Criteria to Create a New Product in WooCommerce from Clover

The Unique Identifier that ties the two systems together is the product SKU. If you only have product codes, export your product list, and copy them into the sku field.

file

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

  • Item SKU has been updated with new database time stamp in POS.
  • Item has SKU in Clover
  • Item has a Weight in Clover (not required)
  • Item is Active in Clover
  • Item has a Product Name in Clover
  • Item has Inventory Value (Zero or higher) in Clover
  • Item has Price Value (Zero or higher) in Clover
  • Item has a Category in Clover
  • Product Description in Clover (not required)

To restrict specific products from going up to your website just add the Label ‘instoreOnly’ in your Clover POS.

See snapshot example for instoreOnly label.

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

  • Item SKU has been updated with new database time stamp in POS.
  • Each Item has a unique SKU in Clover
  • Item has a Weight in Clover (not required)
  • Item is Active in Clover
  • Item has a Product Name in Clover
  • Item has Inventory Value (Zero or higher) in Clover
  • Item has Price Value (Zero or higher) in Clover
  • Item has a Category in Clover
  • Product Description in Clover (not required)

Note: Matrix products need to be built properly in Clover using the POS hardware or the Clover UI.

All SKU’s in Clover must be unique

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 WooCommerce after a new product has been created. You will also need to update your inventory time stamp after in order to trigger new inventory updates.

Note two way inventory sync requires orders sync and item stock update based on WooCommerce orders created in Clover.

file

Action name: Clover adjust item stock for matching orders from WooCommerce then tag orders esyncExported. Please contact us in Support if this Action isn’t visible and we can activate it for you.

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

  • Item has a new time stamp in Clover POS.
  • Item has a SKU in Clover
  • Item is Active in Clover

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

  • Item has a new time stamp in Clover POS.
  • Each Child product Item has a SKU in Clover
  • Item is Active in Clover

Price adjustments in Clover is a trigger to sync new items. When adding new products, we suggest adding the SKU first, and the price update last. If you update price first, the item may sync and if the SKU is missing, the item will fail. If the item failed, because the SKU was missing, now you’ll need to update the price for a new trigger. Change price by a penny, hit save, and change back, hit save again.

Note: The time stamp for creating products in Clover is different from the time stamp to update inventory only in Clover. 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

See list of Actions needed to create products in Shopify from Clover and Sync Inventory file 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

Do you have decimals in your inventory (weighted items?) or non-integers? If so, try this update mentioned on github.

Github Supporting non-integers, decimal inventory.

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

Was this article helpful? Votes: 0