We're adding a catalogue of products using Flat File import.
The products are various luggage accessories for motorcycles, listed by bike manufacturer and then bike model, then year etc.
Some of the products used apply to more than one bike model, therefore there are duplicates.
The first question - is it acceptable to have exact duplicates in a flat file import?
It has all been going fine (many thanks BTW to Leehack who egged me on to give it a go
) until we began adding duplicates.
Because we have been doing the work in chunks - by manufacturer in fact, this has only just come to light.
We load [section] Aprilia, then BMW - so far so good. Then, we load Honda which has some duplicates of products in Aprilia and find the Aprilia 'original' products have vanished while the duplicates appear in Honda perfectly well, although their correct order has altered during the import.
The site is in TEST mode and not yet uploaded. We always clear the whole lot before importing everything again, then adding the latest import batch.
Any ideas and advice hugely appreciated as usual.
The products are various luggage accessories for motorcycles, listed by bike manufacturer and then bike model, then year etc.
Some of the products used apply to more than one bike model, therefore there are duplicates.
The first question - is it acceptable to have exact duplicates in a flat file import?
It has all been going fine (many thanks BTW to Leehack who egged me on to give it a go
) until we began adding duplicates.Because we have been doing the work in chunks - by manufacturer in fact, this has only just come to light.
We load [section] Aprilia, then BMW - so far so good. Then, we load Honda which has some duplicates of products in Aprilia and find the Aprilia 'original' products have vanished while the duplicates appear in Honda perfectly well, although their correct order has altered during the import.
The site is in TEST mode and not yet uploaded. We always clear the whole lot before importing everything again, then adding the latest import batch.
Any ideas and advice hugely appreciated as usual.
Comment