CODEWITHSUNDEEP
phpmysqlwordpresswoocommerce
onurcano
onurcano

Reputation: 415

How do I get / set product price programmatically?

I'm using Woocommerce and trying to make a desktop application which manipulates products and prices (planning to use visual basic).

I've searched the internet a lot however couldn't find a good answer to where the product names and their prices are stored.

Can I manipulate data using php or mysql from desktop?

Upvotes: 1

Views: 1814

Answers (1)

Romuloux
Romuloux

Reputation: 1183

WooCommerce stores products in the 'posts' table of the schema. Instead of manually updating the DB, I would use the provided API.

From there, you can let WooCommerce handle all of the nitty gritty of updating products, managing the data structure, etc.

This also allows you to not have updates to WooCommerce break your application if they change their DB layout.

WooCommerce API v3

Upvotes: 1

Related Questions