Hello i have a problem...
I have import a csv feed of 150.000 but in the mysql i see only 35.000 product!
Why?
Thank's
Thank's David...
But if i add other field in the Product Name for example ISBN or EAN or UPC or MerchantProductID
if other merchant have this product but for example MerchantProduct not is equal,
this product is associate and compare the price?
For example:
Merchant1 have 091202222 Nokia E71
Merchant2 have 211222211 Nokia E71
or
Merchant1 have 07709922 AirMax 1990
Merchant2 have 24562211 AirMax 1990
Thank's
Hello Marco,
This is a common situation with mobile phone feeds - it is normal for the Product Name just to be the name of a handset, so that is why you are seeing lots of products droped.
I think you might have more info in you feed, like Network for example. Check to see if there is a NETWORK field that you could use like I described how to use COLOUR above, and that might let you created product names like
AirMax 1990 Sprint
AirMax 1990 Vodafone
You could include the word " on " in your product names if you like, by making your Text After filter contain:
" on %NETWORK%"
(where NETWORK is the name of the field containing the network name or other information about the mobile phone deal that you can include in the product name to make them more unique)
- note the SPACE at the start again...!
Hope this helps,
All the best,
David.
Cheers,
David.
--
PriceTapestry.com
Hello David,
i try to add some info in product name and category name but not work!
All feeds are in XML !!!
Have any idea?
<product>
<name>polo calvin klein collection</name>
<productUrl>http://pdt.tradedoubler.com/click?a(1329565)p(197970)prod(767449957)ttid(5)url(http%3A%2F%2Fwww.luxyuu.it%2F%2Fproduct_info.php%3Fproducts_id%3D123$
<imageUrl>http://www.luxyuu.it//images/store/S/0964150544-1.jpg</imageUrl>
<description>Polo manica corta chiusura con 3 bottoni piqu&eacute; spacchi laterali logo ricamato composizione: 88% cotone 12% poliestere colore: a righe</$
<price>44.00</price>
<currency>EUR</currency>
<TDProductId>767449957</TDProductId>
<TDCategoryID>800</TDCategoryID>
<TDCategoryName>Abbigliamento Adulto</TDCategoryName>
<merchantCategoryName>polo</merchantCategoryName>
<sku/>
<shortDescription/>
<promoText/>
<previousPrice>135.00</previousPrice>
<warranty/>
<availability>Now</availability>
<inStock/>
<shippingCost/>
<deliveryTime/>
<weight/>
<size/>
<brand>CALVIN KLEIN COLLECTION</brand>
<model/>
<ean/>
<upc/>
<isbn/>
<condition/>
<mpn/>
<techSpecs/>
<manufacturer/>
<programName>LUXYuu.COM </programName>
<programLogoPath>http://hst.tradedoubler.com/file/197970/loghi_TD/logo100.jpg</programLogoPath>
<programId>197970</programId>
<advertiserProductUrl>http://www.luxyuu.it//product_info.php?products_id=123</advertiserProductUrl>
<fields>
<CategoriaCliente>Uomo, Abbigliamento, Polo</CategoriaCliente>
<Sex>Uomo</Sex>
</fields>
</product>For example i like use Sex in category name and TDProductId in name of product but not work...
i try to use %Sex% %SEX% ...
Hi Marco,
It's a sub-element of FIELDS so you will need to use:
%FIELDS/SEX%
That should do the trick!
Cheers,
David.
--
PriceTapestry.com
Hello Marco,
It is not unusual for very large feeds to ultimately import less products that you expect to be in them.
Firstly, for a product to be imported, each of the required fields must be present and valid - these are Product Name, Price and Buy URL.
Secondly, and more likely, each Product Name must be unique per merchant. What can often happen in the case of, say clothing feeds, is that the product name is the same for lots of products, for example "Jumper", but another field in the feed holds additional information that makes the product more unique, like "Colour".
If this happens, you can use Filters to combine the additional information fields with the product name to make more unique product names! Staying with the same example, let's say you have a "COLOUR" field in your feed (where COLOUR is the field name that you see in the sample data on Feed Registration Step 2), and you want to combine that with the product name. After registering the feed, click Filters alongside the feed filename from your /admin/ area, and then add a new Text After filter to the Name field.
In the text box on the configuration page for the filter, enter
" %COLOUR%"
...without quotes, but notice the SPACE at the start - that is important otherwise there will be no space between the product name and colour after import!
Save the filter, and then after the next import, the COLOUR field will be added to the Product Name field to make more unique product names as required!
Cheers,
David.
--
PriceTapestry.com