Auto Categorize Many SKUs In New Data Import

Occasional Visitor

I’ve got a list of about 1,000 SKUs that have been placed in 22 main categories and I’m trying to figure out a fast way to auto categorize each SKU when I import a new report so that I can easily filter through inventory data. Is this possible? (Still learning Excel!)

1 Reply

@cgmretail Would be helpful if you could show a sample of the SKU's you have, how you have categorised them and how "a new report" that required automatic categorisation looks like.

If for instance the main category is based on the first four digits, it's quite easy to attach the correct category to new SKU's.