Attached is an example file.
The cvs has one merchant. The merchant has one product in varying quantities.
"PRODUCT NAME","CATEORY","QTY","DOSAGE","DOSAGE AND QTY","PRICE","ADD TO CART","ADD TO CART URL (WITHOUT KBID)","PRODUCT NAME"
"Product 1 100mg","Product 1",40,"100mg","100mg X 40",75,"http://1.com","http://2.com","Product 1 100mg"
"Product 1 100mg","Product 1",80,"100mg","100mg X 80",125,"http://1.com","http://2.com","Product 1 100mg"
"Product 1 100mg","Product 1",150,"100mg","100mg X 150",189,"http://1.com","http://2.com,"Product 1 100mg"
"Product 1 100mg","Product 1",270,"100mg","100mg X 270",280,"http://1.com","http://2.com","Product 1 100mg"The import only shows the first line into the database.
Other merchants will offer similar products in different quantities.
What is the best way to import and display this information.
Having a separate product with qty will not work as there are vendors have many qty's. Any other suggestions to make something like this work?
{link saved}
Hi Kevin,
It should compare prices like-for-like (same quantity), but do you mean that you want all versions of the same product - in all different quantities - on the same product page?
Cheers,
David.
Hi David,
We need same product, different quantities on the same page.
Merchant ----- Product --------Qty -------Price
Merchant 1 -- Product 1 100mg -- 10 pills -- Price
Merchant 1 -- Product 1 100mg -- 20 pills -- Price
Merchant 2 -- Product 1 100mg -- 15 pills -- Price
Merchant 1 -- Product 1 100mg -- 25 pills -- Price
Merchant 2 -- Product 1 100mg -- 20 pills -- Price
Where category would be Product 1.
Products in the category would be Product 1 50mg, Product 1 100mg, Product 1 200mg etc.
Now we can only import one product -- Product 1 100mg -- per Merchant.
Here is an example link.
{link saved}
Customers can compare several quantities from the same merchant.
Thanks.
Hi,
I'll follow up by email for you - it can be done but there's a few steps involved and it will be easier to keep track by email with regards to file changes etc...
Cheers,
David.
Hi,
As you've discovered, the product name must be unique per merchant; hence only one product is imported as it stands. The thing to do here is to use filters to combine one of the other fields in your feed that contains more specific product information with the Product Name field to create proper unique names.
From the sample data; it looks like "QTY" would work well combined with the Product Name field; so to use that field; add a new Text After filter to the Product Name field for this feed. On the configuration page for the new filter, enter the following:
" x %QTY%"
- without the quotes, but note the SPACE at the start - that is important, otherwise the combined product name won't have a space between the 2 field values. %QTY% is a placeholder that pulls in the value of that field name for the same record; thus creating your unique product names, for example:
"Product 1 100mg x 40"
A similar situation is often encountered in clothing product feeds; where a common product name is only further resolved in other fields, such as "COLOUR" and "SIZE".
After adding the filter, don't forget to re-import the feed for the changes to take effect.
Hope this helps!
Cheers,
David.