Thanks for your inputs guys.
Retail only allows one category per item. If you want to add an item to more than one category, you have to do it in eCom. A good way to manage sales is to add items to a sales category (for instance "Boxing Day") to group them and be able to redirect
And yes, Lightspeed is not a true omni-channel solution in that regards. You have to create the item in Retail and redo most of the work again in eCom (images, tags, prices, they even had a Description field in Retail that did not sync with eCom (it has been renamed to Notes since)). A lot of our work ends up being duplicated when creating or updating an item.
"The current ways of remembering by heart all the items in a category, looking them up on the website/export so that we can type them one by one in the filter and edit them or going through the entire product list only clicking on the products we know are in a category don't cut it."This is actually one way that the import tool is pretty helpful, since to see all the products in a category, you would just sort the category columns alphabetically. Then you wouldn't need to have to remember which products belong to which category, and you can bulk edit those on the list.I know you mentioned that the import tool is not ideal for what you're hoping to do, so I'm sure this doesn't solve the issue. Just wanted to offer my two cents on that piece in particular.
Indeed, the export tool can filter things for you and then you can type the items one by one in eCom to modify them as you'd like.
Indeed, the export tool can filter things for you and then you can type the items one by one in eCom to modify them as you'd like.Just to clarify, once you have the products filtered in a spreadsheet you can add, for example, the "Boxing Day" category. Then import the spreadsheet back into eCom and the categories are added to the product (original categories are not removed).You can import data back into eCom without clicking each product in eCom. Just note, you can not make changes to fields that are controlled by Retail, like Stock, Brand and Sell Price. But you can import Tags, Descriptions, Meta info, Images, etc. The Product Content field can also be exported and imported with the HTML, regardless if it has comma's, quotes or periods.I made an FAQ about imports in case you want more information on Imports.
Correct, categories are added.HTML can be added without problem. The Text Delimiter will make sure commas and code are ignored, which I usually set to doube quotes ". If you use OpenOffice or LibreOffice you will be asked to set the text delimiter:The software itself will automatically take care of the text delimiters and even with the HTML it will import just fine.