Documentation

SkuBrain 101

Shopify Integration

Hooking skuBrain up to your shop in Shopify is super simple. Immediately after you create a new forecasting project, on the sales dashboard you’ll see a Shopify icon:

Click on that and you’ll be taken to a page where you can provide your Shopify shop name. When you save the settings, skuBrain will redirect you to Shopify’s app store so that you can authorize the application to access your Shop’s data.1

Importing your sales history

Once you’ve connected skuBrain to your Shopify shop, you’ll see an “Import from Shopify” button on your sales dashboard in skuBrain.

You’ll need to import your sales history before you can create a forecast. Once skuBrain has your sales history though, it can generate forecasts without needing to connect to Shopify.

Replenishment planning

Later on, once you have a forecast in skuBrain you’ll want to use this to plan what you need to reorder by creating a stock plan. In order to create a stock plan, skuBrain needs to know:

  1. How many units you have in stock for each of the products you sell
  2. The lead times for acquiring stock from each of your suppliers

skuBrain will automatically fetch stock availability from Shopify. The lead times for each of the suppliers is something you’ll need to provide manually, since this isn’t stored anywhere in Shopify. However skuBrain makes it easy to supply this information. Each time you create a stock plan in skuBrain you will see a list of suppliers along with the lead times that you have configured for each of these, so that you can alter these if necessary.

Obviously, this information gets stored so you’ll probably only need to configure this the very first time that you create a replenishment report. After that, the only time you’ll need to change anything is if you change suppliers.

Creating purchase orders

Shopify doesn’t have much in the way of inventory management features built in, and has no notion of “minimum inventory levels” or “supplier orders”.

However skuBrain’s stock plans can be downloaded as CSV files and opened in Excel or Google Sheets or whatever, so generating purchase orders directly from skuBrain should be relatively straight forward.

Notes

  1. If you don’t complete the authorization process in Shopify, skuBrain’s connection to your Shopify store will be a broken… you can fix this by changing the ERP Integration settings for your project back to None in the Project Settings (select Project | Settings on the menu in skuBrain - you’ll find the ERP Integration Settings on the Config tab of the settings).