commercetools / commercetools/commercetools-sunrise-data

product.csv contains products in not existing category

Open
#75 1 comment 0 reactions 0 assignees View on GitHub
content
Dominant language
JavaScript
Stars
43
Forks
73
PR merge metrics
No merged PRs in 30d

Description

The product.csv contains products in the category `Wies\'n Special`which does not exist.

~$ /app/node_modules/.bin/product-csv-sync import --projectKey 'sunrise' --accessToken 'pAyiFiCcRBM7hF_c-lcjS6s56ST5PAMh' --csv '/app/1493231564219_products.csv' --language 'en' --csvDelimiter ',' --multiValueDelimiter ';' --sphereHost 'api.commercetools.co' --sphereProtocol 'https' --dryRun --matchBy sku --encoding 'utf8'

Loading has finished
Initializing resources
CSV file with 26150 row(s) loaded.
For the product type 'main' the following attributes don't have a matching header:
sapExternalId: type 'text ' - constraint 'Unique' - optional
Mapping 2973 product(s) ...
[ '[row 3676:categories] Can not find category for \'Wies\'n Special\'!',
'[row 8884:categories] Can not find category for \'Wies\'n Special\'!',
'[row 9551:categories] Can not find category for \'Wies\'n Special\'!',
'[row 14306:categories] Can not find category for \'Wies\'n Special\'!' ]
[ '[row 3676:categories] Can not find category for \'Wies\'n Special\'!',
'[row 8884:categories] Can not find category for \'Wies\'n Special\'!',
'[row 9551:categories] Can not find category for \'Wies\'n Special\'!',
'[row 14306:categories] Can not find category for \'Wies\'n Special\'!' ]

Process exited with code (1)

Contributor guide

No contributing guide indexed for this repository

Research direction

Inspect the product.csv entries reported at rows 3676, 8884, 9551, and 14306, then compare the `Wies'n Special` value with the available category data. Rerun the shown product-csv-sync dry-run command to verify that no products reference a missing category and that the import completes without these errors.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript
Domain
data
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.