Product module import help desperately needed!!!

Have a question or a suggestion about a 3rd party addon module or plugin?
Let us know here.
Post Reply
geeves
Forum Members
Forum Members
Posts: 114
Joined: Wed Dec 03, 2008 4:56 am

Product module import help desperately needed!!!

Post by geeves »

Hi guys.

I have the import feature working nicely in the products module, however, when I select the 'Overwrite' option of the 'How to handle duplicate products?' section, I notice that products are deleted from the database first, then overwritten.

Below is the code (starting from line 422) of class.csv_importer.php in the products module

Code: Select all

// uh-oh, it's a duplicate product.
	if( $this->_getPolicyValue('skip_existing_products') )
	  {
	    // woohoo, we get to skip this whole line
	    $this->_setError("duplicate product $name");
	  }
	else
	  {
	    // uh-oh we gotta delete this existing product first.
	    $this->_module->DeleteProduct($t_id);
	  }
      }
If the product is first deleted, then re-added, the ID of the specific product will change because its auto increment value is updated.

Can anyone offer any suggestions to fix this? When I say to 'overwrite' a duplicate product, I would like it to update a value/row in a table, not delete and re-insert.

When a product is deleted and re-inserted, its URL changes. So if someone bookmarks the product at this url, then U update the product, it will no longer appear at that url (for example below)

www.yoursite.com/products/42/41/bn11110028 (<----- last number is product code/name in my case)
Last edited by geeves on Fri Jul 10, 2009 3:17 am, edited 1 time in total.
Ara Garabedian
Multimedia Designer / Developer
http://ara.ifky.com.au
geeves
Forum Members
Forum Members
Posts: 114
Joined: Wed Dec 03, 2008 4:56 am

Re: Product module import help desperately needed!!!

Post by geeves »

Can anyone help with this at all please? I hate bumping my own posts but really need some answers.
Ara Garabedian
Multimedia Designer / Developer
http://ara.ifky.com.au
sudestmanceau
Forum Members
Forum Members
Posts: 21
Joined: Tue Apr 14, 2009 3:02 pm

Re: Product module import help desperately needed!!!

Post by sudestmanceau »

Got the same problem !
And we can add that it seems not possible to delete all products with only one click !
Is there a solution ?
Post Reply

Return to “Modules/Add-Ons”