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.
โ