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. On top of Connex, click rules engine.
  6. Click add rule.
  7. Choose Shopify from the select selling channel.
  8. From templates, choose mapping Shopify inventory site and click next:
  9. Scroll down and edit the rules grid.
  10. Enter a SKU to use for the rule.

For the rules, what fields can I compare?

Here are the fields:

  1. Product SKU (QuickBooks item name)
  2. Product name (QuickBooks sales description)
  3. Product Warehouse (QuickBooks item inventory site)

You could say if the QuickBooks item inventory site is LGP-Warehouse, then sync the site to the LGP-Warehouse in Shopify.

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 settings.
  3. Choose Shopify.
  4. Click inventory setting.
  5. Click the warehouse filter:
  6. Under inventory sites to export, select a list of sites:

  7. Ensure your QuickBooks inventory site and Shopify inventory site names are a match.