Follow the below steps to import the history Inventory COGS and sales into ScanPower.
Step 1: Create a spreadsheet with the following columns (or use the template attached to this solution) with the History Sales and COGS to be imported into ScanPower.
Column Name | Description | Required |
Order ID | Is the Amazon Order ID | Yes |
MSKU | MSKU of the Item | Yes |
Quantity Shipped | # of units purchased (Should be equal to the units Sold) | Yes |
Supplier | The supplier or Source of the item | Yes |
Buy Cost | COGS of total units of the item | Yes |
Date Purchased | The date you purchased the item to sell (default to 1 day before the item sold) | Optional |
Step 2: Navigate to Inventory Lab Import page. https://unity.scanpower.com/inventory/ilab
Step 3: Go to "Import FBA Sales" on the IL Import Webpage and import the spreadsheet prepared in Step 1 (above). It may take several hours for the information to populate, depending on the size of the file.
Step 4: After uploading data to ScanPower you will receive notifications when the report is processed.
Once complete, the History Sales and COGS will be updated with the filled information.
Please Note:
- Keep the data sheet "Import Data" in Tab 1 of the spreadsheet.
- Sales price, Sales date, # of units sold and other sales fields will be pulled from API call to Amazon using the entered order#.
- Moving forward, ScanPower will maintain your costs and calculate COGS for order using FIFO accounting.
- Import the spreadsheet only once and wait for the notification. Verify by searching with Order ID in the order details report.
if you do not find the uploaded data, open a support ticket with us.