Hi! I have a little issue I hope you guys can help me with.
I have a setup with 2 storefronts. Some products are owned by store 1, others by store 2.
Now, I'd like to put a word (the brand name) in front of the product names for 1 store, so that the invoices and packing slips sort per brand. I do not want this to happen on the other store.
I thought I could make this work with an export - import but I can't seem to get it to do what I want.
I can make an excel sheet so that all the products get the correct name but with the different stores, I'm not sure how to import it correctly.
Would someone know a way to do this? I'd be very grateful. Thanks :)
<p>I can make an excel sheet so that all the products get the correct name. </p>
It's possible to rename the products belonging to the 1st store on the product pages of the 2nd store. But I can't find a way to do it with a mass edit.
You can't do it when changing to the context of the desired company?
If you know the mapping, you can do it via phpMyAdmin given the company_id is part of each row in the cscart_product_descriptions table. If you have the "Brand" in some other area like a feature, you could probably do it with a JOIN to that feature and then use a mysql concat() string function to append the brand name.....
In phpMyAdmin you can check cscart_ult_product_descriptions table. You should find all rows for required company_id and change value of the product column.
However... it doesn't solve my problem: The products on orders, invoices and packing slips are still sorted by product name, but it uses the names the products have in All Suppliers or the main storefront - not the name of the current store. Makes sense? No. But it's certainly true.
So I guess my question is now: How can I sort the products nicely per brand and then product name of all Suppliers, or... simply per product name of the store the order is in?