You are here:  » Duplicates on Import

Support Forum



Duplicates on Import

Submitted by Keeop on Sat, 2009-03-28 08:26 in

Hi David,

Not sure what I've done but I'm sure you'll be able to help me out! On importing a feed, instead of just dropping any duplicate records my import will now stop with a 'Duplicate entry' error. Any ideas on how to suppress this message and get it back to just not importing dupes?

Cheers.
Keeop

Submitted by support on Sat, 2009-03-28 10:05

Hi Keeop,

That sounds like you're still running the debug version of database.php. Replace includes/database.php with the original (from the distribution) and that will be all it is....

(the duplicate prevention is achieved by virtue of the SQL failing, so it's not actually an error as such)

Cheers,
David.

Submitted by Keeop on Sat, 2009-03-28 10:40

Thanks David.

Submitted by Syed on Mon, 2010-04-12 14:59

Hello David,

My feed contains data with identical name. And i want to load identical data for name field. Currently the duplicate data are rejected. Is it possible to load the identical data for name field?

Cheers,
Syed

Submitted by support on Mon, 2010-04-12 15:12

Hello Syed,

Lots of the functionality of the script is geared around the product name field being unique per merchant - that's how the comparison is ultimately applied of course as the search engine "GROUP"s by `name`.

Could you describe a little more of the requirement for having the same product name and how you would want it to work?

There is a common scenario that can be handled with Price Tapestry's filter system whereby feeds have identical product names, e.g. "Jumper", but then other fields in the feed resolve them into different products, such as `size` and `colour`. In this case, the additional fields can be combined with the product name using Text After / Before filters and placeholders to refer to other fields in the feed, e.g. %SIZE% to combine the size field, giving unique product names such as "Small Jumper", "Large Jumper" etc - that might be something that could work in your scenario...

Cheers,
David.

Submitted by Syed on Mon, 2010-04-12 16:27

Thanks David, Filters worked well for my scenario...

Cheers,
Syed