My client is selling some adult toys, only physical toys. Please be aware of this.
Regarding Easy Populate contribution, after I open a downloaded file with excel, the first few columns are for product picture, product name, etc, and the last few columns are for manufacturer, category and EOREOR. The columns in the middle are for product attributes, such as color, size, etc.
For my products, each color/size has one model number. For example, let's say I have three products:
AA149504 Pink color
AA149505 Purple color
AA149506 Flesh color
Instead of creating three products, I use the product attributes feature to group them together into ONE product. To differentiate them, I put AA1495 as the model number, and then list Pink-04, Purple-05, Flesh-06 in attributes fields.
As you know, Easy Populate pulls "all the attributes" of all products and put them cell by cell in each product in the txt file.
The following is a sample file with only one product (AA1495) plus the header. If you open it by txt editor, you will see how big it is with all those attributes. The real three attribute "Pink-04, Purple-05, Flesh-06" for this product were hidden in the middle.
[url removed, login to view]
This not only cause the easy populate file so big, but also make it impossible for people to search by model name. If people search AA149504, they get nothing. They have to search AA1495 to find the product.
So question is:
1. Is there a way to tell Easy Populate only download the attributes with individual product, do not download the attributes from other products? This way, the downloaded file can be much smaller.
2. Whether there is a way to allow buyer to search the whole model number and find the product by looking the model number + attribute number?
Alternatively, I wonder whether there is a way to display only 1 product on my store page even though I have all three models entered by easy populate. Take my above example:
AA149504 Full name is: "Candle Holder Pink"
AA149505 Full name is: "Candle Holder Purple"
AA149506 Full name is: "Candle Holder Flesh"
Is it possible only show ONE "Candle Holder" in the store page.
Thank you for reading my long post. If you have done similar project before, please provide it to me in message.