Importing your accounting details (I.e., Buy Cost, Supplier, and Date Purchased) is the quickest and most efficient way to add this data to your inventory.
Note: Importing your costs will not work for items that have replenishments. For these, you will need to add the accounting information manually in order to properly edit the correct replenishment sort sequence.
Click the Inventory tab at the top of your screen and select either FBA or Merchant from the drop-down menu
Click the Export button at the top right:
Save the exported .CSV formatted spreadsheet to your computer.
Open your exported spreadsheet and enter the price per unit, supplier, and/or date purchased information to each of the MSKUs you’d like to update.
- Guidelines for adding buy costs/price per unit: Enter buy costs without a “$” sign or “-“ (negative/minus) sign. Ex. Your buy cost= $4.15 per piece. Enter as 4.15 (Do not enter as “$4.15” or “-4.15”)
- Guidelines for adding purchase dates: Enter dates as MM/DD/YY or MM/DD/YYYY
Remember to SAVE the updated spreadsheet and return to your InventoryLab account to complete the importing process.
Return back to the same Inventory screen you exported your data from by again clicking Inventory then FBA or Merchant from the dropdown
This time, click the Import button at the top right.
You’ll see a popup screen that asks you to choose the file you’d like to import. Locate the saved file on your computer and click Next.
The next popup allows you to match the MSKU, (Buy Cost), Supplier, and Date Purchased fields in InventoryLab with the column titles in the .CSV formatted spreadsheet.
The required fields of MSKU and Cost/Unit are in red
Select the corresponding columns for each field and click Next.
Once imported, these changes can take up to 20 minutes to be updated in your account.