REST API for Stores > Catalog: Query Doesn't Return All Products

Ask the community
,
1

I wrote a PHP program that recursively retrieves all products in the catalog using the Stores > Catalog REST API. See process here: https://dev.wix.com/docs/rest/business-solutions/stores/catalog/filter-and-sort

Back in April it was returning all of the products. Now it is only returning 462 of the 29,000+ products in the catalog. Those 462 products are very old. I verified the wix_site_id and Authorization key. I use other REST APIs in my programs multiple times each week.

Is there a bug or a new version?

2

I resolved the problem. The situation is that Heartland Outlet uses both WIX Online and WIX POS. Not all products in the store are available online. So we “hide” the items only sold in stores. That is, 462 items are sold online while over 29,000 are products to sell in the store.

The solution is to alter the URL as follows: https://www.wixapis.com/stores/v1/products/query?includeHiddenProducts=true