Title: Update all via database
Last modified: August 31, 2016

---

# Update all via database

 *  [DesFab](https://wordpress.org/support/users/desfab/)
 * (@desfab)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/update-all-via-database/)
 * Hi,
    I am currently using your plugin which works great. I am using CSV upload
   for my products and with the plugin I am using I cannot set the Sample area meaning
   I would have to go into each product and do this manually. As this will take 
   ages I wondered if I could do this via the database? I have located my products
   in my wp_posts table but cannot see where the field for the sample is so I can
   write an SQL query.
 * Thanks,
    Becks
 * [https://wordpress.org/plugins/woocommerce-sample/](https://wordpress.org/plugins/woocommerce-sample/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  [Juan-Uniq](https://wordpress.org/support/users/juan-uniq/)
 * (@juan-uniq)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-6903889)
 * Hi, I am in the same situation.
    Please if you find out a way, could you let 
   me know?
 *  Thread Starter [DesFab](https://wordpress.org/support/users/desfab/)
 * (@desfab)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-6903890)
 * Hi,
    I have found a solution although I have not created the sql query yet but
   I have found the correct area/fields of the database.
 * Go to your database area and you are looking for a table called wp_postsmeta 
   and you can see the fields you need by running query;
 * SELECT * FROM `wp_postmeta` WHERE meta_key LIKE ‘%Sample%’
 * Once all my products are added to the site I am going to create a new SQL query
   to update all to;
 * sample_enamble = 1
    sample_price_mode = custom sample_price = 0.99 sample_shipping_mode
   = FREE
 * Sorry I have not written query yet and won’t be for a bit but hopefully this 
   will help you.
 *  [Juan-Uniq](https://wordpress.org/support/users/juan-uniq/)
 * (@juan-uniq)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-6903891)
 * Thanks, i will take a look to it.
 *  Thread Starter [DesFab](https://wordpress.org/support/users/desfab/)
 * (@desfab)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-6903921)
 * How did you get on with this – trying to write my sql code now and its more complex
   than I imagined!
 *  [Juan-Uniq](https://wordpress.org/support/users/juan-uniq/)
 * (@juan-uniq)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-6903922)
 * Actually, you will need to create entries for enable the product.
    then update
   the rows on wp_postmeta. Finally my client is doing it manually, because also
   want to do some changes on the products.
 *  Thread Starter [DesFab](https://wordpress.org/support/users/desfab/)
 * (@desfab)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-6903925)
 * Has anyone got any ideas about this as I am stuck!
 *  [Juan-Uniq](https://wordpress.org/support/users/juan-uniq/)
 * (@juan-uniq)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-6903926)
 * If you use all in one import, you can update custom fields, where appears all
   fields you need. check it and write me back if you have any question.
 *  [lifestylefloorsdirect](https://wordpress.org/support/users/lifestylefloorsdirect/)
 * (@lifestylefloorsdirect)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-8167658)
 * Did you find a solution to this?
 *  [Juan-Uniq](https://wordpress.org/support/users/juan-uniq/)
 * (@juan-uniq)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-8283545)
 * I change the way setting up as variable products. with Real product and Sample
   products as variations

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Update all via database’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/woocommerce-sample_e38233.svg)
 * [WooCommerce Sample](https://wordpress.org/plugins/woocommerce-sample/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-sample/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-sample/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-sample/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-sample/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-sample/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 9 replies
 * 3 participants
 * Last reply from: [Juan-Uniq](https://wordpress.org/support/users/juan-uniq/)
 * Last activity: [9 years, 7 months ago](https://wordpress.org/support/topic/update-all-via-database/#post-8283545)
 * Status: not resolved