Excel uploads

Hi,

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

[email protected] wrote:
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!

Cheers,
Reha

Hi,

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.

Is there a way to fix this?

Cheers,

In case this was not clear, below is the data I get when I export a product:



So to rephrase my question how should I set up the 3rd, 4th and 5th lines to make sure the total in the below image is 0?


Many thanks,
Reha