If you are changing platforms that are connected to Inventory Planner, we've put together a checklist to help transfer your information.
If you are adding a platform, use this process instead.
- Create a new Inventory Planner account.
- Connect your new platform.
- If needed, import sales history.
- Transfer past stockout data.
- Transfer vendor catalogs.
- Set lead time and days of stock for new warehouses.
- Update replenishment status.
- Transfer purchase orders and transfers.
Note that we are unable to retain stock history information but you can export it from your old account for reference.
Add New Store Connection(s)
- To create a new Inventory Planner account, please sign up at https://www.inventory-planner.com/signup then follow instructions in the "New Store Connection" section below.
- To keep the same existing account but add a new store connection to replace another, follow the instructions in the "Replace Store Connection" section below. Once added, contact the IP Team to disable the old account (disables syncing & billing, but keeps data in tact while transitioning systems).
Once you've transferred over all necessary data, simply remove the old connection by selecting the trash can icon in Account > Settings > Connections to the right of the connection.
New Store Connection (start a new account)
Connecting Your Store
After you create an account, click on the platform that you want to connect to Inventory Planner on the page 'Let's connect your store'.
Note: If you use an Inventory Management System (such as Skubana or QuickBooks Commerce), then you only need to connect that platform. If you sell on Shopify and Amazon for example, all of your data from those connections will flow through your inventory management system.
After selecting the platform to connect, enter information in fields provided. These fields will vary by platform. Additional instructions may be provided on that page to help you locate the needed information. For example, additional instructions for connecting your Amazon account can be found below the 'Connect' button starting with 'Enabling the API access for your Amazon shop'.
When you have entered information into these fields, click 'Connect'. Your data will start to sync with Inventory Planner. Depending on the order volume and number of variants, this initial sync can take up to a few hours to complete.
You will then be asked if you want to create a new account or to connect to an existing account. We recommend that you create a new account here.
Replace Store Connection (keep the same account)
If you would like to add additional stores or connections to your Inventory Planner account and/or remove existing connections, click 'Account' in the lower left corner, then 'Settings'.
Select 'Connect Another Platform' to add your eCommerce platform or inventory management system.
You will then be asked if you want to create a new account or to connect to an existing account. If you want product, vendor, and purchase order information all showing in the same account, then select an existing account. If you want all information separate, then click on 'Create new account'.
If you need additional information specific to your platform or system, check out our Integrations collection in the Help Center.
Import sales history (optional)
If your new platform will contain your sales history, then that information will sync to Inventory Planner. If your new platform will not have sales history, then you need to load it into Inventory Planner so that a forecast can be generated.
Imported sales should not overlap with data already available in Inventory Planner. For example, if sales data from your platform starts September 1, then your import data should go up to August 31 only.
To import sales history, follow the instructions in our article.
Transfer Past Stockout Data
Inventory Planner takes into account past stockouts when calculating the forecast and replenishment recommendations. If you have stockout history or stock level history available from another store, you can export the information then import past stockout into your new Inventory Planner account. This can help to improve the accuracy of your forecasts.
* Note: importing stockout or stock level history does not adjust the stored stock history, only the number of stockouts.
Transfer Vendor Catalogs
If you have one vendor per product and all vendors are in the same currency, you can export the replenishment report. Then, you'll import this into your new account as a Multiple Vendor Catalog.
If you have more than one vendor per product or multiple currencies, please contact Inventory Planner so that we can assist you with this transition.
Set lead time and days of stock for new warehouses
In order to product accurate replenishment recommendations, you will need to set the lead time and days of stock for your products.
The lead time is the amount of time that elapses between placing a purchase order and receiving products.
Days of stock is a period of time for which you’d like to have enough stock, or, in other words, the stock cover.
You can update lead time and days of stock:
- By vendor (supplier)
- Individually by variant
- In bulk for variants through Bulk Actions
- In bulk for variants through import
Recommended: You can export lead time and days of stock from your old account and import it to your new account. In your old account, go to Replenishment. Make sure that your 'lead time' and 'days of stock' columns are showing on the report. Click on the gear icon in the upper right to add them if needed. Finally, click 'Export' at the bottom of the screen.
Follow the import instructions at the bottom of this article: How can I set the lead time and days of stock?
Update replenishment status
To remove items from your forecast that you do not keep in stock (including dropshipped or discontinued items), go to the Replenishment report and select items you wish to remove.
Then click Bulk Actions > 'Set Non-Replenishable'
The default view of your Replenishment report shows replenishable items. If you wish to view items that are non-replenishable, remove the Replenishable filter.
Importing Non-Replenishable Status
If you have a spreadsheet of variants (SKUs) that need to be set as non-replenishable, you can import that information.
Recommended: In your old account, apply the 'Replenishable' = 'no' filter first. Then export this information.
Follow import instructions here: How to hide or remove dropshipped or discontinued items from the forecast
Transfer Purchase Orders and Transfers
To export your purchase orders from your old account, go to the Purchase Orders & Transfers section. Click Actions at the bottom of the page, then Export PO line items.
Then follow these instructions to Import a Purchase Order or Transfer.