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).
-
Leslie Kirk
Miva Certified Developer
Miva Merchant Specialist since 1997
Previously of Webs Your Way (aka Leslie Nord leslienord)
Email me: [email protected]
www.lesliekirk.com
Follow me: X | Facebook | Pinterest
-
Admin > Home > Data Management > Import/Export > Export Categories To Flat FileOriginally posted by lesliekirk View Post
Thank you, Bill 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...Originally posted by William Davis View PostLeslie Kirk
Miva Certified Developer
Miva Merchant Specialist since 1997
Previously of Webs Your Way (aka Leslie Nord leslienord)
Email me: [email protected]
www.lesliekirk.com
Follow me: X | Facebook | Pinterest
Comment
-
I totally understand now. This is a classic lookup/bring-back job using Excel. This is essentially what you need:Originally posted by lesliekirk View Post- 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.
Last edited by William Davis; 08-13-25, 08:07 AM.Thank you, Bill DavisComment
Comment