Filter not working

Hi esia168,

Thanks for using our plugin and reaching out to us. Sorry to hear you are experiencing issues.

We have tried to replicate the issue at hand but all works just fine for us, like it does on your localhost environment.

I am going to ask the obvious here: do you have a product on your production environment that has the specific SKU filled in? Or does your SKU attribute has a different name?

All the best,
Eva

Hi, in the production I have the SKU number filled in the inventory tab of the product edit page.

My localhost environment database is a copy of the production database. So they should have the same data.

Also it’s strange that when I import the database of the production, all my feeds in Manage Feeds are gone in localhost, I have to create a new feed from the scratch. Where is the feed setting stored ? Not in the database ?

I want to generate the feed from my localhost because the feed processing takes a huge cpu power and cause my web server to hang. I wonder if there’s a solution for this also ?

Thanks

• This reply was modified 6 years, 1 month ago by esia168.

The settings of your plugin configurations are saved using so-called WP-options. See: https://codex.www.ads-software.com/Options_API

The Options API is a simple and standardized way of storing data in the database.

The plugin is already designed to not use too much CPU. That is why the plugin is processing product feeds in small batches. It really shouldn’t hang your server unless you are running an old version of PHP and trying to process tens-of-thousands of products.

Best,
Eva

• This reply was modified 6 years, 1 month ago by evavangelooven.

Hi, I have copied the whole database and import, why does the at the manage feeds, no feeds are available ? What could be the cause ? Version difference ? Also, it really once when I start the processing, it’s using a high cpu resource when I check with uptime command, there are 150 processing queue, I am using php 7.2 , hosted in google VM with 1 vCpu and 4GB RAM, debian linux, that should be enough. I think there’s some configuration issue ?

The product info says :
You currently have 2209 published products on your website out of which 98 are single products and 2111 are variable products.

Is this a lot ?

• This reply was modified 6 years, 1 month ago by esia168.
• This reply was modified 6 years, 1 month ago by esia168.

To be honest: we have no idea what the effect is on copying a WP-database to another database and what the effect of that is on our plugin and the previously configured feeds on your localhost. I am afraid we cannot help you with that.

With regards to usage of resources: of course it does take CPU power to generate the product feeds but like I mentioned we think it is not using it excessively. Especially as it starts a new process every time a new batch kicks off, preventing CPS usage to run too high stalling the webserver.

https://www.dropbox.com/s/ka3dhu4pns8n42b/mem-usage.jpg?dl=0

Anyhow: “too high” is in the in the eye of the beholder. So if it is acceptable or not is really up to you.

Sorry we can’t help you any further with the issues you have copying the databases.

All the best,
Eva

• This reply was modified 6 years, 1 month ago by evavangelooven.

Assuming our support is no longer required on this issue I am going to close the topic now for housekeeping reasons.

Please feel free to reach out again whenever you need help.

All the best,
Eva