Hello,
one site uses Apple I-Phone 3GS
other site uses: IPhone 3g S
I see in the admin panel product mapping.
but my situation is a little different: I dont use feed imports, i get the product data right from a database and i am planning to use price tapestry just for the front end. my data from a database is going to be imported to price tapestry database with the help of a custom script.
I can define the same products with different names manually.
I suppose that the product database and mapping database tables are different.. that is because I can manually map same products with different names together only once. my products database table will be truncated and re filled with fresh data everyday. But i cannot manually map the same products with slightly different names together everyday.
I need help and advice on this point.. its a little complicated so i will try to put it this way:
1) I will not use any feeds. rather, my price tapestry database product table will be truncated and re-filled with fresh product data everyday, by a custom script.
2) I can manually mark the same products with slightly different names. but i can do it only once, not every time my product table is updated.
3) I want to know which price tapestry database table holds the product mapping data.. Will product mapping data be lost when the products table is truncated?
4) If product mapping data is stored in a table other than the database table "products", will the product mapping still work (the product names that i marked to indicate that they are the same product) when the "products" database table is truncated and re-filled with fresh data?
sorry for the bad english..
i understand. i am going to have to consult you again, on this topic, when making the custom script.
Hello,
Product Mapping data is held in the `productsmap` table, and it is not touched even if you truncate (empty) the products table.
Under normal operation, the Product Mapping is applied during import; so when a product is about to be INSERTed into the database, the Product Mapping table is checked for any alternative entries that match this product; and there is a match, the product name is replaced with the master product name from the mapping.
Depending on how your custom script to import data is to be implemented, it could well be possible for you to implement product mapping the same way; although this would of course require you to have involvement with the Price Tapestry /admin/ area. Let me point you at the appropriate sections of code; firstly, the Product Mapping table is loaded into an array at the start of the import process - see includes/admin.php lines 402-419, and is applied during the import record handler function, in the same file at lines 236-266...
Cheers,
David.
--
PriceTapestry.com