Export Category Names with Products

[William Davis]

Yes, I know. But I need the Category NAMES with the Product Export. I have over 9800 products with category CODES that need the Category NAMES assigned to them...

I totally understand now. This is a classic lookup/bring-back job using Excel. This is essentially what you need:

• You have two separate Excel files (let’s call them File A and File B).
• There’s a common field in both files (e.g., an ID, SKU, name, or some other unique key) that should match across them.
• For each matching record, you want to pull another value from the same row in File B into the correct row in File A.
• The pulled value should land in File A in the row where the match occurred.
• Essentially, you want a cross-reference between two files — match on one column, bring back a related column’s value.

Let me know if you need "How To".

[lesliekirk]

Admin > Home > Data Management > Import/Export > Export Categories To Flat File

Yes, I know. But I need the Category NAMES with the Product Export. I have over 9800 products with category CODES that need the Category NAMES assigned to them...

[William Davis]

Is there any way to export the Category Names (not Category Code) with the Product? I have over 9800 products that I need the category name they are assigned to. I'm trying to create a custom field for a search filter since the shows the Parent Category has to be clicked on to show the category name the product is assigned to. The site has 1800 active category codes. Using the custom field will also help since many of the categories have the same name (which is okay in this case).

Admin > Home > Data Management > Import/Export > Export Categories To Flat File

[lesliekirk]

Is there any way to export the Category Names (not Category Code) with the Product? I have over 9800 products that I need the category name they are assigned to. I'm trying to create a custom field for a search filter since the shows the Parent Category has to be clicked on to show the category name the product is assigned to. The site has 1800 active category codes. Using the custom field will also help since many of the categories have the same name (which is okay in this case).