search

liquidweb / woocommerce-custom-orders-table

Store WooCommerce order data in a custom table for improved performance.
GNU General Public License v3.0
476 stars 51 forks source link

Multi store compatibility #169

Closed okbk closed 2 years ago

okbk commented 4 years ago

Hello,

We're using WooCommerce Multistore (https://woomultistore.com/) to handle stores for different locations.

We are using the Custom Order Table however it is only working on the default store. For all additional stores a lot of the order data is missing - because it can't find the table.

I manually created another table for the second store (basically prefixed it with 2). I'm wondering 2 things...

  1. it seems to now work for the additional stores (which is great) - am I missing something?
  2. if all is well, could this be added to the install script to check for additional stores and create tables as necessary?

Thanks

stevegrunwell commented 4 years ago

Hey @okbk,

Thank you for bringing this to our attention, we definitely want to make sure that the custom orders table plugin is adhering to proper table prefixing practices. We'll make sure this gets addressed!

ryonwhyte commented 4 years ago

Hey @stevegrunwell,

Do you think it is safe enough for me to use this plugin on a live single store website? Selling a single product but may have many orders per day. Sorry for asking under this issue, but I do not know where to ask a question.

Thank you

okbk commented 4 years ago

@stevegrunwell Can I just check that since I've manually added the table - it'll work correctly across both stores?

stevegrunwell commented 4 years ago

@ryonwhyte We've been running the latest release candidate on a number of large, production customer sites for months without issue. That being said, this is still technically pre-release software, so please be aware of the current known issues that are to be addressed before the official release of version 1.0.0. There may also be some manual upgrade/migration steps required when moving to 1.0.0, but we are being very intentional in outlining those upgrade steps (for example, see the release notes for past releases).

@okbk The plugin is using the conventional $wpdb->prefix variable anywhere table names are referenced, so it should work as expected once the table is created. I'm going to keep this issue to open to make sure we're automatically creating the orders table for each site in a network if in a multisite (or, as you referenced, a multistore) configuration.

ryonwhyte commented 4 years ago

Thank you very much @stevegrunwell. I will install and do a few test and see if everything works fine. I will be sure to update here if any bugs are found. I will be sending orders to WooCommerce via REST API from my mobile app. Lets see how it works. Thanks again!