Batch Delete of Products

[sbronstad]

Re: Batch Delete of Prodcuts

Okay, just saw the post right above mine... I guess great minds think alike :-)

[lesliekirk]

I seem to find myself coming back to very old posts to see if any new methods have been created. I want to be able to delete product with a flat-file import. Is this doable yet?

Geez, if I didn't know better, my posts to these very old posts might trigger spammer flags (good thing I'm a moderator )

[PCINET - Andreas]

easiest we are using is assign products to a inactive category and delete all products in that category. It's two step but doesn't take much longer than a one-step.

[papi34]

Sebenza's Product Delete Import Module still works great after all these years, but it looks like they are out of business :(

[PCINET - Andreas]

Sebenza's Product Delete Import Module still works great after all these years, but it looks like they are out of business :(

yeah, was the easiest way but you can't get the module anymore and it may break something in future Miva versions. So careful using it in the future.

[joseibarra]

We are still using the Sebenza module in our ReadyTheme stores - can't say much for the "reporting", no log file, etc. but it works and I trust it to behave.

The link in a previous post says the store is closed...

Back in 2015 Brennan reports:

As of today module developer Sebenza is no longer selling their modules. While we were aware of their plans to get out of the module business, we were not aware of the timing.

We have been planning for quite some time to “replace” the functionality provided by the Sebenza modules and build it into the core of Miva. The next release of Miva (9.0003) due out this Spring replaces the bulk of the functionality provided by the Sebenza modules. In addition to these updates to Miva itself, some active 3^rdparty developers will be releasing their own modules to cover features which we will not be building into the core product.

I'll see if I can find the module.

[joseibarra]

I found the module which is a Miva .mvc file to add.

If you would like me to send it to you I'm not sure how to deliver it to you

Let me stick it on my OneDrive and send you a link to it - but that will be later since my lunch is ready.

Description in their PDF:

Product Delete Import
Product Description:
This import utility allows you to delete mass amounts of products via a flat file upload.
Key Features:
Flat File Export

[lesliekirk]

easiest we are using is assign products to a inactive category and delete all products in that category. It's two step but doesn't take much longer than a one-step.

Well, easy for you and me...

[lesliekirk]

I found the module which is a Miva .mvc file to add.

If you would like me to send it to you I'm not sure how to deliver it to you

Let me stick it on my OneDrive and send you a link to it - but that will be later since my lunch is ready.

Description in their PDF:

Product Delete Import
Product Description:
This import utility allows you to delete mass amounts of products via a flat file upload.
Key Features:
Flat File Export

I would love to see what you found. FYI, just got off the phone with Miva Support - they are recommending using an XML. Now I get to try and create one for around 600 products.

[PCINET - Andreas]

I would love to see what you found. FYI, just got off the phone with Miva Support - they are recommending using an XML. Now I get to try and create one for around 600 products.

Yes, an XML will actually delete the products but creating the file is more complicated than the way I described :P

[joseibarra]

Here is a link to the ZIP file:

https://1drv.ms/u/s!AlzCDddLSsKoghMSK49warA3loWP?e=R013bk

Let me know either way if the download works.

I'm hoping you know how to add modules to Miva.

It should show up in Miva Admin under Menu, Utilities. I made a Miva bookmark in the interest of economy of clicks.

Launch it, click where it says Module admin is here and navigate it your text file.

Just make a flat text file (the Data File), one part number per line.

Sometimes we delete a hundred++ products a week and add a new hundred to keep on top of the competitors.

[Bruce - PhosphorMedia]

Yes, this still may be something to partition Miva to build as I would be VERY wary of using that old module. There is a very good chance, given its age, that is does not have the not_prod() functions that are used by other sub-systems such as Price Groups (for example, if a product is deleted that was in a price group, the not_prod() function would inform the Price Group to remove it. While this may not cause a specific Run Time issue, it, at the very least leads to poor site hygiene.

And that's just one "for instance"

Just out of curiosity, even if your not using price groups, could you (Joseibarra) do a test the next time you run this and see if it does remove a product from a price group?

[lesliekirk]

Installing the module was the easy part. Needing a license key could be a game stopper.

Andreas, I don't disagree with how you are suggesting to do this, it's brilliant, but I have been given an Excel spreadsheet with the product codes that need to be deleted. I may just create a merge file to wrap the XML formatting around every product code unless someone has an easier way to do this.

And yeah, I know - I'm in the MM5.5 forum and I'm working with an MM9 store (yeah, yeah...I know).

[Bruce - PhosphorMedia]

hmm...if you want a repeatable method, you could build your own 'product delete' tool in a store template (i'd protect this one REAL carefully :) ) using

<mvt:do file="g.Module_Library_DB" name="l.success" value="Product_Delete_ID(id)" />

If it could wait a day or two, would be happy to write it for you (getting ready to launch a year long site)

[Bruce - PhosphorMedia]

If I remember correctly, that function is used to 'pre-test' an XML structure...and it failed...so where the products (other than the ones it couldn't find) actually deleted?