Database structure

Below you will find an overview of all database tables of WooMex. These database tables are created when the respective plugins are installed in your WordPress database.

woomex_exported_orders

Name	Type	Null	Default / Extra
`id` Primary key	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
`order_id`	`BIGINT(20)`	`NO`	`NONE`
`status`	`VARCHAR(255)`	`NO`	`pending`
`payment_status`	`VARCHAR(255)`	`NO`	`pending`
`invoice_status`	`VARCHAR(255)`	`NO`	`pending`
`cancellation_invoice_status`	`VARCHAR(255)`	`NO`	`pending`
`delivery_status`	`VARCHAR(255)`	`NO`	`pending`
`date_exported`	`TIMESTAMP`	`NO`	`CURRENT_TIMESTAMP`

woomex_automatic_product_imports

Name	Type	Null	Default / Extra
`id` Primary key	`BIGINT(20)`	`NO`	`NONE \| AUTO_INCREMENT`
`collmex_product_id`	`VARCHAR(255)`	`YES`	`NULL`
`status`	`VARCHAR(255)`	`NO`	`NONE`
`updated`	`TINYINT(1)`	`YES`	`0`
`date_imported`	`TIMESTAMP`	`NO`	`CURRENT_TIMESTAMP`