Jump to content

[Resolved] Mass Product Description Changes


Christopher Short

Recommended Posts

Depends what you want to do.

If the edit is to change a wortd or two, then an UPDATE query should work.

More than that, I suggest you find a CSV Editor dedicated to the task of editing and managing CSV files. As always, there are free, but competent, tools with a basic, but common, feature set. Then there are not so free applications that can do wonders on a CSV file. A spreadasheet is NOT the tool to use on a CSV file, even though spreaadsheets usually read and write CSV files. They are horrible at managing the data in them.

Have phpMyAdmin dump the inventory table to a CSV, make your edits as efficiently as possible, then import the CSV back into a truncated table.

 

Link to comment
Share on other sites

This can be done en mass with an SQL query.

Using PHPMyAdmin, first make a backup copy of the inventory table call it something like CubeCart_inventory-copy, and work on this backup copy.

 

Run the following SQL query

UPDATE `CubeCart_inventory-copy`

SET `description` = replace(description, 'old-unwanted-phrase', 'new-wanted-phrase')

 

Alternatively, as BSmither suggests, you could export cubecart_inventory as a csv file, then perform a 'find & replace' with something like MS Ecell.

Once you've made your ammendments, using PHPMyAdmin, truncate (empty) the backup copy, and import your CSV back in.

When you are happy that the inventory tables are to your satisfaction, again using PHPMyAdmin, rename the origianl CubeCart_inventory to something like CubeCart_inventory-orig (just in case)

And then rename your backup copy to CubeCart_inventory.

 

Only when you are 200% satisfied that it's all OK should you delete the original (even if at all, maybe leave it there for future reference)

 

 

 

Link to comment
Share on other sites

On 3/16/2017 at 3:43 PM, Dirty Butter said:

Great! What worked for you?

http://www.g7cart.com/home/index.php?p=viewProd&productId=17&prod=Data Pump (Bulk Import/update/export)

this worked well, except the one import where I had 14000 commas at the end of the description entry....that caused my add to cart question earlier. :)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...