2 Shopify Stores Inactive Inventory Items Issue

@rkenna Acumatica keeps one Item Status per item, and both stores write to it. Every time a store imports a product, the connector sets Item Status from that store's product status. Active becomes Active and Draft becomes Inactive. It matches the product to an existing item by SKU (Inventory ID first, then the Global and External SKU alternate IDs), so a B2C product with the same SKU as a B2B item updates that same item.

Look up one of the SKUs that went inactive in the other store. If it's there as a Draft product, that's your cause.

There's no per-store item status, so the fix is on the Shopify side. If an item has to exist in both stores, keep it Active in both and leave it off the sales channels in the store that doesn't sell it. Item Status comes from the product status alone, not from where it's published, so the next import sets the item back to Active.

One catch. If the item entity on a store is Bidirectional instead of Import, an export from Acumatica publishes an Active product to every sales channel in that store. In that case add Export Filtering for the entity on Entities (BC202000) for each store, by item class or an attribute, so each store only gets its own items.

Try it on one SKU before you change the rest.

Thanks for this ​@Steve Milner, I do wish the Acumatica Shopify connector has a way to intercept those inactive Items easily so they did not get marked as Inactive in Acumatica. We are seeing managing inventory (and product availability) issues with a few members with several Shopify stores.

@rkenna There's a hook if you want to go the customization route. The import maps each product in MapBucketImport on SPStockItemProcessor, and SPNonStockItemProcessor and SPTemplateItemProcessor have their own. It's public and overridable, and the connector creates its processors as graphs, so a graph extension with a PXOverride can call the base and then keep the stored Item Status when the incoming product is Draft. The processor knows which store it's running for, so the rule can apply only to the store that doesn't own the item.

Keep Visibility too. A Draft product also sets the item to Invisible, and if the store that sells it exports, an Invisible item gets unpublished from every sales channel there.

We haven't built this, so try it on one item first.