Importing accounting details into your inventory is easy, and should be the first step you take once your inventory has finished syncing from Seller Central! Just follow the steps below.
Additionally, if your item no longer exists in your inventory, you can update the buy cost information in bulk in your Sales pages.
1. Navigate to Inventory>FBA or Merchant.
2. Click the stacked dots and choose Export Inventory Data.
3. Open up your exported file and update the cost/unit, supplier, purchase quantity, and/or date purchased information. You can also add tags for MSKUs to import them in bulk.
Some things to keep in mind when importing:
- You can import up to 2000 MSKUs at a time.
- Cost/unit can NOT have a $ character and date must be Month/Day/4 digit year.
- When including multiple tags for the same MSKU, they must be separated by spaces.
- At this time, the maximum number of tags that can be imported per MSKU is 16.
- Individual tags must be 16 characters or less.
4. When you are ready to import, navigate back into your inventory page in Stratify. Click the 3 stacked dots and choose Import Inventory Data.
5. Click Browse and select the file on your computer. Then, click Validate.
6. The next screen allows you to match the fields in InventoryLab with the columns in your .CSV file. The required fields are indicated in Red.
7. After selecting the correct columns for Stratify to import from for each field, click Process File.
8. You will be taken to a validation screen.
If everything is great for a specific MSKU and set to import, you will see a green "Review Complete" message next to it in the Review column.
If not, you'll see a red message in the Review column and options to correct the issue in the Actions column. You can take action individually or in bulk at the bottom of the page:
Note: Items with replenishments can be added to a bulk draft. It does NOT carry over purchasing information, as the system wouldn't know whether it needs to be a new replenishment or carried to an existing one.
9. Once everything is looking good and all issues are corrected, click Complete Review.
10. You will see a confirmation of what will be updated. Click the confirmation to apply the updates to the MSKUs.
That’s it! You should now receive an "Import Success" message.
Note: Imported changes can take up to 20 minutes to take effect on your account.