Adding Same Field to Multiple Products.

[amillioninthemaking]

Hi,

I’ve spend a lot of time entering almost 1,500 products into the shopping cart. Now I will need to make a few adjustments, such as checking the box, must accept terms and conditions before downloading as well as adding the link for the terms and conditions.

There will be other similar things that need to be done in bulk. There must be a way to add the same value in bulk to all items.

Please advise how to do this.

Thanks

Matt

[admin]

The terms and conditions checkbox is a global setting (not per product). Simply go to eStore settings and specify it there (you do it only once).

[amillioninthemaking]

That makes that part of it easier, but what about other fields that need to be changed in bulk. Fields that are not in global settings.

Also, if it is a global setting, is it possible to leave certain products out of the terms and conditions, or to have a secondary terms and conditions? For example, someone buying customization services would be quite different than someone buying the template.

Thanks

Matt

[Peter]

Hi Matt,

If you would like to do bulk editing you are best served to do it via PHPMyAdmin using a csv file.

Watch this video which will explain exactly how to do this:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[amillioninthemaking]

Thanks for the info. Watched the video, got it setup, downloaded the csv file. Everything looks in order. Although I still have a question.

In the video, when Importing Table, it says to check “Replace table data with file”.

I dont see too many other options here.

Will it work if I delete all columns except the ID column and the column I want to update?

Eg: I only want to update Product Page URL

So I can leave ID column and product_url column.

Also If the details from a column in the spreadsheet are deleted, will they also be deleted during the import?

Thanks Again

Matt

[amillioninthemaking]

Hi, checking back in. Its been 2 days and no reply.

Could someone reply please.

Thanks

[admin]

Simply empty the table content (PHPMyAdmin lets you empty a table content with 2 clicks) then import your file again (this way you are always have the same details of your csv file in the product database).

[amillioninthemaking]

Thank you for the reply. Although I would still like an answer to my initial question.

****Will it work if I delete all columns except the ID column and the column I want to update?

Eg: I only want to update Product Page URL

So I can leave ID column and product_url column only.****

****Also If the details from a column in the spreadsheet are deleted, will they also be deleted during the import?****

I’ve spent 100 hours or more entering this data into the shopping cart. I dont want to mess with anything. I only want to add a bit of info into several columns. Can I add only specific columns via phpmyadmin import??

Thank You

Matt

[admin]

I am not a PHPMyAdmin expert and when it comes to database related stuff always backup your database then do whatever. With that said, yes if you tell it to update those columns it should only update those columns. Simply backup your database (very easy to do from PHPMyAdmin) and then try it out. If it doesn’t work the way you expected you can just restore it.

[amillioninthemaking]

Thanks.

Just being on the safe side. Dont want to lose what I did.

On a side not…

Since the category table is seperate, if I make changes to the main table, will I lose the categories? I assume not.

Please let me know.

Thanks again

Matt

[admin]

No you should not lose the categories if you make changes in the main table (as long as the product Ids stay the same).

[Author]

Posts