We are using NopCommerce 3.8, I have 2 questions; 1- Can we update product descriptions with Excel uploads? When I try, I get success message but the description of the product remains the same. 2- Can we update SEO through Excel uploads? In the template (that I generated with an export) I am not seeing the fields Meta keywords, Meta Description, Meta Title
We are using NopCommerce 3.8, I have 2 questions; 1- Can we update product descriptions with Excel uploads? When I try, I get success message but the description of the product remains the same. 2- Can we update SEO through Excel uploads? In the template (that I generated with an export) I am not seeing the fields Meta keywords, Meta Description, Meta Title
Cheers, Reha
1- Yes make sure that in your upload you include the SKU of the corresponding products. Try an Excel export of some products, then change their descriptions and import and see the results. 2. I think you can: The exported template includes only the fields selected for the Basic mode. When adding/editing any product click on the "Settings" tab (top left menu) and then select "SEO" option; save and export a template.
Thanks! 1- Apparently I had a product specific issue, as when I try again now I see that some products are updated some not. PS: I am having Invalid column name 'id'. Invalid column name 'id'. Invalid column name 'id'. error for each item even though they are updated. 2- Thanks, this was what I was looking for!
I have a follow up here, I have updated some of the products and noticed that created values for product attributes. As you can see from the attached image the Value Totals are 1 whilst I want them to be 0. I tried uploading the excel by removing the product attributes, by making the attributeValueId = -1 or 0 or empty but non of these worked.