Forum Discussion

cgmretail's avatar
cgmretail
Copper Contributor
Jun 10, 2022

Auto Categorize Many SKUs In New Data Import

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

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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.

Resources