cheatingdanger

Thank you for this response. I have been playing with postman and can retrieve all products and can’t find duplication. Based on this I don’t think my problem is with WooCommerce or the database. I appreciate the help provided, I am going to fiddle with the other links in the chain. The info is being pulled into Google Sheets and formatted into columns.

// sheet information
    var header = ['ID', 
                  'Name', 
                  'SKU', 
                  'Price', 
                  'StockQty'];
    var items = [header];

It is baffling to me that 97% is working as expected and 3% is being weird. Thanks for the help I will have to investigate the other end.

* Pick 2-3 of the products that are not included and being pushed by duplicates.

Can you find them when doing this request: https://woocommerce.github.io/woocommerce-rest-api-docs/#retrieve-a-product ?

I am able to find them this way. The correct product is fetched and clearly exists.

* Pick 2-3 of the products that are showing up as duplicates.
* Open phpmyadmin and search for the product IDs. Do you get more than one result?

Under wp_posts and wp_postmeta I could not find any duplication. A search sometimes found 4 hits but browsing the results would show 1 of the results to have the matching product id in the “ID column” with the expected product name in “post title”. The other matches were not duplications but tags or category matches.

Hi Con a11n

We have 270 products on the website. Each with a unique product id. They are viewable on the site with stock levels and price values. Normal, straight forward everything as you would expect. If I perform a product export as csv all 270 products show up as expected.

If I run an API GET call I received products which are output to a spreadsheet. The spreadsheet has 270 lines/products. I was doing VLOOKUP’s on the ID's and 8 products were missing values. I ran a search and those product ID's had no match they don't appear in the retrieved data. I could not understand how I got the right number of items (270) but 8 products were not included. I then searched duplicates and found 8 products appearing in the list twice. I keep getting this result. 

I can see no relation between which products are duplicated or the ones that are missing. They are not next to each other in the list, they are not neighbours in product ID. They not falling over the page break or due to some offset setting as far as I can tell.

Two months ago I had the same issue. I followed the advice above to roll back. This has worked but two months on I still can’t upgrade to the latest version without the error reoccurring. For testing I tried to create a new form, I can’t even do that any more. I just get an error “The link you followed has expired.” I am interested if any of you with this error have tried to make a new form?