Efficient way to Import Product Attributes from a list of 1000+ Products

Good Evening.

I'm new to NopCommerce 4.0 and I try to leran more about it day by day but know I dont know how to solve this.
So my problem is that i have a giant xls list with Products.
Obviously the format from the list isnt in the same forma as NopCommerce would like it.
So i have articel numbers etc. and i have Colour, Size and material.
I asked myself how I can Import Attributes.
So i made test Products with attributes and did a export to see how i can organize them.
My only Idea to import all attributes for every Product is to:
Add manuel every Product Attribute like Colour Square etc. and export it,
Import every Product without Attributes ,
make a new xls where I copy and paste every product line by line and
add the certain Attributes with the before exported Attributes.

Does anyone have a more efficient way for my problem or do I missunderstand somethink orI dont know.
Ah and the Producs have sometimes the colour or size Implanted in the Titel ad sometimes dont.

Thank You.

RickEliRamon wrote:

Hello

I've recently had the requirement to import attributes, options and maps the options to products. There are around 85k rows. First I tried this in code, it works but it is very very slow. It was taking many minutes (5+) to complete. In the end I did it sql, and it was far easier and faster, around 6 seconds to import the attributes, options and map all the options to products.

What tables did you use / update?

So far I have found SpecificationAttribute, SpecificationAttributeOptions and Product_SpecificationAttribute_Mapping.

Am I missing any?

Artdtc wrote:

Yes just those three tables.

Artdtc wrote:

There are also ProductAttributes, which are different from SpecificationAttributes. There are similarly named tables for the ProductAttributes but columns are different as they have different uses.

You may find it easier to import the data into a new table(s), it will make it easier to work with.