Multiple Shopify Stores Integration

Shopify Integration allows you to connect multiple Shopify Sites to your system.

Stores are synced at the host company level. Different host companies can have different stores sync records if required.

Each SKU can be set to Sync

• no shopify store

• one shopify store

• multiple shopify stores

• Flag by store if Prices are synced

• Flag by store if stock levels are synced

You can mass update SKU’s using the play area.

• Option shows when Shopify Integration is setup on the host company.

Same SKU in different Host Company Shopify Stores

Where a global SKU is

• Stocked in one host company (company A)

• Sold from either host company Shopify Store (Company A and Company B )

Best with an example

1. Host Company A sells and stocks Product A

   1. The SKU is setup to sync to their shopify store

   2. The dirty stock list indicates if any transactions not from Shopify have occurred

   3. The available stock is synced after every order pickup and limited to the dirty sku list - which is then emptied

   4. Every night a full stock available stock sync is completed

2. Host Company B also sells Product A - but (1) has no stock and (2) has setup the brand as supplied by the supplier “Host Company A” (supplier > Supplier > Brands)

   1. The SKU is setup in Host company A to sync to their shopif store

   2. The dirty stock list is ignored (as no stock is held in Host company B )

   3. The available stock using stock levels from Company A is synced after every order pickup (all stock supplied by Company A is updated).

   4. The dirty stock list in company A is not affected.

Pickup Orders and update stock levels

Orders picked up within minutes and stock updated for

Comparing Shopify SKU’s

The sync process gets all the Shopify SKU’s and compares the list with existing SaaSplications SKU’s capturing the Shopify reference key and listing any not found in either system.

These attributes are managed from SaaSplications once Synced for product Variants

1. SKU code

2. SKU Title

3. SKU Description

4. Shopify Status (always set to draft when new then left to Shopify)

5. Cost Price (average cost)

6. Barcode

7. Compare Price (Old RRP)

8. Price (RRP)

9. Requires Shipping

10. Tracked

11. Taxable

The sync process is initiated from the SKU screen (use a blank screen to sync all products)

Note: Daemon process updates this information into Shopify every night

Update product Name and Title (Description) is only updated if updated manually or new products

Mapping

Sales Orders and Available Stock

Frequency of picking up orders then sending available stock levels is set per store. A fast moving store may be every few minutes, a slow moving store may be every 15 mins.

Every night a product sync and available stock update is done across all stock items.

Anytime a manual update can be done to update a shopify store with all products and all stock levels.

Available stock - is NOT current stock levels - it is available stock after existing stock requirements (eg unpicked orders).

Dirty Stock - dirty stock had a change outside shopify orders. If the only change to stock levels is new shopify orders - the SKU is NOT considered dirty. Generally during the day only dirty stock is updated to shopify for performance reasons.

Create a new SKU in Saasplications and Shopify

If you create a new SKU is Saasplications and want it to be sold in Shopify you will need to set the SKU up to sync with Shopify

Each night around 11 PM the Saasplication SKUs will be synced to Shopify and create new SKUs in Shopify

Open

Confirm Shopify SKU Sync

Currently this can only be used to spot check the Sync to shopify

Copy one of the SKUs in the Session Manager for the latest sync to Shopify (Either full or dirty and either foneking1 or flightrisk)

SearchCode:EBIKEMIRRORRM15, Qty:33, API: Shopify (foneking1), API ID: gid://shopify/Product/9825452753215

In Shopify Live - Inventory - Search for that SKU

Open

Click on Adjustment history - confirm when the last Inventory correction was done

Open

Sales Report to import Shopify Orders

Sales Manager - Sales Reports - Action - Shopify (foneking1) Order API

Click and orders for the date range will be imported

Results will appear in a note on screen

Open

Update SKU information in Shopify from Saasplications

If you need to update SKU information in Shopify due to errors reported by Email from Sync Updates

Copy the SKU from the email and paste it into Shopify

Confirm that

New SKU information in Shopify from Saasplications

Create the SKU in Saasplications

Shopify SKU Reconciliation Process

Checks for issues in Shopify and fixes where single SKU is found in Shopify and updates mapping if required

This requires the user to have the Shopify Integrations role which has the is EDI Manager secure feature

Stock - Stock Article

Open

(1) a SKU in our system that IS mapped to a shopify Product / Variant - AND duplicates are found - you are alerted to delete duplicates in Shopify (if you delete the currently mapped one - we will map the remaining one).

(2) a SKU in our system that IS NOT mapped to a shopify Product Variant - AND duplicates are found in shopify - you are alerted to delete duplicates in Shopify so we can then map the remaining one.

(3) a SKU NOT in our system - is indicated as an "Unknown SKU"