Knowledge Base

SKUs

If you have multiple SKUs for a single ASIN, this list of SKUs can be longer than your ASINs list.

There are a few things you can do in the Products | SKUs area.  Probably the biggest thing you do in the SKUs area is editing the Cost of Goods.

Editing COGs

In order to get the best possible calculation of Profit, you’ll want to include your Cost of Goods, and Inbound Shipping, if any.  Products | SKUs is where you do this.

Here's a short video overview, followed by written steps:

You can do this one product at a time, by clicking the edit button.  You get an edit screen for that SKU:

Add costs and select the desired currency.  Your account currency will show by default.

Note that you can also set differing costs for specific date ranges.  To add a new range, click the + and add a date through which the costs were valid, then enter that Cost and Inbound Shipping, if any.  You can do this for additional ranges if needed, by clicking the + and following the same steps to add the next most recent date, and setting the costs that were applicable through that date.

Once your Costs are set, click Save.  They are applied.

Bulk Editing COGs

If you have a large number of SKUs it will probably be easier to use the Bulk Edit functions.  Click Bulk Edit:

And you get additional buttons on your rows of products:

You can use these buttons to save individual rows or save all at once.

Using  Bulk Edit change the cost of an item instantly by editing the figure in the cost field.  When you click away from the field it is saved immediately for that SKU, and this figure will be used from now on.  It basically works the same way as clicking on the SAVE button.

The SAVE+0 button saves the cost to the SKU and also updates all past transactions in the system where the cost for this SKU is “0”.

The SAVE+ALL button saves the cost to the SKU and also updates all transactions in the history of this SKU, overriding any previously set cost.

Using these buttons only updates the data for this one SKU.

If you want to update the data for all SKUs globally, you need to use the Bulk Edit buttons at the top or bottom of the page for that.

Those buttons will apply the same rules to all product rows.

When done use the “Exit Bulk Edit” button to clear those buttons.

You can also update the Cost fields using a CSV file.

To start, first Export your current data.

If you click on the EXPORT CSV button, this will export your data to a CSV file. You can then edit the figures in the Cost column and import the file back.

Update the CSV file as desired, then click to “Import CSV”.

Note: you can only make changes to the Cost and Inbound fields.  You can not make changes to the product names and upload them.

After the import, the system will show you any errors and it will switch you to Bulk Edit mode, where you can check the values and choose what to do – SAVE, SAVE+0, SAVE+ALL, row by row or globally for all the imported lines.

Note:  please pay close attention when you use the Bulk Edit mode.  Make sure it is what you want to do before you click on Save.  It is not something that is easily undone, so make sure you choose the Save+ option that is best for you.

Hiding Products

If desired you can hide product so they do not appear on your Inventory Management or Product Metrics screens.  This could be useful if you have an inactive or discontinued product, which still has past sales data but is no longer in inventory, or no longer needs to be monitored.

Under Settings | SKUs you can choose to do this by making the product invisible.  If you click to Edit any product you’ll see a “Visible” checkbox.

By unchecking and saving that value, the product will not show.  To restore it, edit the SKU and check the box, click Save and it will once again be visible.