Shopify

How do I change the Shopify location where Connex sends inventory?

Connex uses a default inventory site. You can use our rules engine to override it.

Problem

Your stock updates fail from QuickBooks to Shopify and you get this error in the log:

An item cannot be active at more than one location if one of them is a fulfillment service location.

Description

Shopify supports multi location inventory. Our software sends the Shopify product, its new stock level, and the Shopify location where inventory is located. By default, our software uses the default Shopify location for your store. If you have a fulfillment location, you must override the logic. 

Solutions

There are two ways to solve the error. You can map certain products to certain locations or map the QuickBooks inventory site to Shopify. 

Add Rule

We will say if the product SKU is 2.05.00132, then map LGP-Warehouse as the Shopify product location. Mapping a warehouse like ABC123 will cause the update to fail, since the product is only available at the LGP-Warehouse and the SLS-Warehouse fields.

  1. In Shopify, open the product.
  2. Open the locations.
  3. Note what locations are available. In this case, you can send LGP-Warehouse or SLS-Warehouse:
  4. Please note mapping a location under app will fail. Your inventory location must be available under locations: 
  5. Go to the Connex rules engine.
  6. Click add rule.
  7. Choose map field, based on a condition.
  8. Enter map product as the action.
  9. In the rules area, click add.
  10. Enter SKU, Equals, and 2.05.00132.
  11. Enter LGP-Warehouse:

Enable sync inventory by site

Our tool will map the QuickBooks inventory site location to the Shopify inventory site field. No rules or additional set-up is required. If you have 5 widgets in your Boston site, then Connex will map qty of 10 to Shopify's Boston site. Here is an example of what Connex would send to Shopify:

Site Quantity
Boston 10
New York 5

To map inventory by site, follow these steps:

  1. Login to Connex.
  2. Click manage.
  3. Expand inventory > advanced inventory.
  4. Under inventory sites to export, select a list of sites:
  5. If no sites appear, click update drop downs on the top right of Connex. 
  6. Ensure your QuickBooks inventory site and Shopify inventory site names are a match.