All Collections
Managing Your Product Catalog
Adding/Deleting Product Variations and SKUs
Adding/Deleting Product Variations and SKUs

How to manage your catalog in WholeCell and map it to E-commerce sales channels

Brennan Zelener avatar
Written by Brennan Zelener
Updated over a week ago

In WholeCell, Product Variations are a combination of:

  • product (manufacturer, model, variant, network, capacity, and color)

  • grade

  • conditions (damage conditions)

A SKU is an attribute of a Product Variation. You can assign the same SKU to multiple Product Variations if duplicate SKUs are enabled in your settings.

Adding New Product Variations

A new WholeCell account will have a default catalog of products, but will have zero Product Variations until you add inventory or upload a spreadsheet of product variations with "create" in the ID field of the Product Variations spreadsheet template:

Your downloaded sheet will show blanks on the SKU column if you haven't uploaded them yet.

Managing SKUs

SKUs can be edited in bulk via Product Variation spreadsheet upload or manually from a Product Variation's page.

Sample spreadsheet with added Product Variations/SKUs:

WholeCell will not create in the catalog the entry in any row if the cells under the manufacturer, model, variant, network, capacity, color, and grade columns are blank. If you do not wish to add details for any of those product specifications, you must at least put "unknown" on the cells that you want to skip.

Note: You can edit the SKU but you can't edit the product variation (any product attributes, grade, and damages). If you need to have a different variation, you will need to create a new one for it. If you want to use the SKU that is the same as another variation for this new one, you can do so as long as you enable the duplicate SKU setting here.

You can't also upload multiple SKUs for a product variation. WholeCell will only create one SKU for a specific product variation.

Manually update the SKU (one by one):

Another way to set SKUs in bulk (aside from the spreadsheet upload method):

Delete product variations one by one:

Bulk-delete product variations:

Did this answer your question?