products weren't updated but no error message

Solved
pferdinand
Tourist
3 1 0

Hi,

I recognized that around 4-14% of the products included in CSV were not updated, but didn't get any error message in the popup or the email summary.

The case is the same with 90 products and 22 000. Example file: https://cdn.shopify.com/s/files/1/0533/7759/7594/files/Shopy-prod-update_5_-_BAAAAAAA_random.csv?v=1... (3 row was missed)

I tried to get products that were updated before a datetime via API ( 2021-04 version: products.json?updated_at_max=2021-05-06T16:15:47-04:00&status=activefields=id,Variant_SKU) but it returned 0 results.

I would need to urgently update the prices but the support failed to provide me the solution in the last 24 hours.

Experts, can you solve?

0 Likes
makkysolutions
Excursionist
31 1 2

I can definately help you automate the import and make sure it works and also generate report

Drop me email ajayoemail@gmail.com

pferdinand
Tourist
3 1 0
Hi,
See the updated table below. As ignored lines from split table and different (split3) and table with randomly selected rows (BAAAAAAA) share a similar rate (4-14%) + the fact I don't get any error message (I used to get weeks before so I know how it looks in the Import popup and the notification email) leads me to the feeling that the problem is NOT with given rows.

Code Rows contained Rows updated Rows missed Success Update started (CET) Download URL
1 21439 19997 1442 93.3% May 9, 2021, 12:07 am
May 9, 2021, 2:01 pm
May 10, 2021, 11:11 am https://cdn.shopify.com/s/files/1/0533/7759/7594/files/update_5.csv?v=1620655219
B 11439 10664 775 93.2% May 10, 2021, 3:50 pm https://cdn.shopify.com/s/files/1/0533/7759/7594/files/B.csv?v=1620672660
BA 5000 4652 348 93.0% May 10, 2021, 20:54 pm https://cdn.shopify.com/s/files/1/0533/7759/7594/files/BA.csv?v=1620672865
BAA 2500 2337 163 93.5% May 10, 2021, 10:23 pm https://cdn.shopify.com/s/files/1/0533/7759/7594/files/BAA.csv?v=1620678179
BAAA 1250 1178 72 94.2% May 11, 2021, 9:13 am https://cdn.shopify.com/s/files/1/0533/7759/7594/files/BAAA.csv?v=1620717196
BAAAA 750 713 37 95.1% May 11, 2021, 9:33 am https://cdn.shopify.com/s/files/1/0533/7759/7594/files/Shopy-prod-update_5_-_BAAAA.csv?v=1620718410
BAAAAAAA 94 (randomly selected) 91 3 96.8% May 11, 2021, 10:21 am https://cdn.shopify.com/s/files/1/0533/7759/7594/files/Shopy-prod-update_5_-_BAAAAAAA_random.csv?v=1...
split3 3999 3471 528 86.8% May 11, 2021, 11:27 am https://cdn.shopify.com/s/files/1/0533/7759/7594/files/update-with-hu-desc_1_-3.csv?v=1620729740

I didn't understand this: "Saw that you had a few CSVs there. Is that latest one the CSV with the products that are seemingly not being loaded? There is 751 products on it so its a little short of the 1k we expected but this might just mean that some of the earlier products that had an issue were uploaded." I included the download links of the highlighted CSVs in the table. I call them highlighted because I don't know when this upload ignorance started, maybe from my registration.

I need the solution urgently.
0 Likes
pferdinand
Tourist
3 1 0

This is an accepted solution.

Thanks for the support to finally point to the reasons:

  1. some column headers contained _ instead of whitespace, so were ignored
  2. some rows were identical except in those columns so they weren't updated
  3. some rows had blank Handles due to my bad deduplication method
0 Likes