Adding new CategoryName and ProductName Fields ?

[Eric33]

Dear all,

I'm new to AC. I've been testing AC7 and it almost meets my customer requirements, but there still is one pending issue: I need to be able to display the category names and product names (and only these 2 fields) in 2 different languages (Spanish and English).

Explanation:
- my prospect only has 10 customers (subsidiaries) and his site will be in English (the site will only be used for intra-company transactions, between subsidiaries of the same Group)
- for QA reasons, product names and category names need to be displayed in Spanish for himself and in English for his subsidiaries
- for inventory reasons, the ProductID should be unique per product (we would prefer not to have a product in Spanish and a duplicate one in English)

Anyone has any idea of how I could deal with this ?

Many many thanks for your help !

[Shopping Cart Admin]

Hello,

I'm not sure how or where the information will be 'output' by we'd typically recommend adding a new table or tables in this case, while referencing the id's of the English products and categories.
e.g.
able_Category_titles_S
Category_ID, SpanishTitle