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 :)
I can make an excel sheet so that all the products get the correct name.
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?