Skip to content

Instantly share code, notes, and snippets.

View AndreasMartin84's full-sized avatar

AndreasMartin84

View GitHub Profile
aw_product_id,product_name,aw_deep_link,search_price,rrp_price,merchant_id,merchant_name,aw_image_url,aw_thumb_url,merchant_image_url,category_name,merchant_category,brand_name,model_number,currency,delivery_time,in_stock,promotional_text,specifications
10001,Brother Innov-is A16 Sewing Machine,https://www.awin1.com/cread.php?awinmid=12345&awinaffid=67890&clickref=&p=https://example.com/brother-innov-is-a16,289.99,349.99,55666,Sewing Direct,https://www.brothersewingshop.co.uk/image/cachewebp/catalog/Brother/brother%20sh40-1000x1000.webp,https://www.brothersewingshop.co.uk/image/cachewebp/catalog/Brother/brother%20sh40-1000x1000.webp,https://www.brothersewingshop.co.uk/image/cachewebp/catalog/Logo/brothersewingshoplogo-150x48.webp,Sewing Machines,Home & Garden > Crafts > Sewing,Brother,Innov-is A16,GBP,3-5 days,Y,Save £50 on this computerized machine!,LCD display|16 stitches|Automatic needle threader|Free arm
10002,Janome 2212 Sewing Machine,https://www.awin1.com/cread.php?awinmid=12345&awinaffid=67890&clickre
aw_product_id,product_name,aw_deep_link,search_price,rrp_price,merchant_id,merchant_name,aw_image_url,aw_thumb_url,merchant_image_url,category_name,merchant_category,brand_name,model_number,currency,delivery_time,in_stock,promotional_text,specifications
10001,Brother Innov-is A16 Sewing Machine,https://www.awin1.com/cread.php?awinmid=12345&awinaffid=67890&clickref=&p=https://example.com/brother-innov-is-a16,299.99,349.99,12345,Sewing Direct,https://www.brothersewingshop.co.uk/image/cachewebp/catalog/Brother/brother%20sh40-1000x1000.webp,https://www.brothersewingshop.co.uk/image/cachewebp/catalog/Brother/brother%20sh40-1000x1000.webp,https://www.brothersewingshop.co.uk/image/cachewebp/catalog/Logo/brothersewingshoplogo-150x48.webp,Sewing Machines,Home & Garden > Crafts > Sewing,Brother,Innov-is A16,GBP,3-5 days,Y,Save £50 on this computerized machine!,LCD display|16 stitches|Automatic needle threader|Free arm
10002,Janome 2212 Sewing Machine,https://www.awin1.com/cread.php?awinmid=12345&awinaffid=67890&clickre
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 19 columns, instead of 9 in line 2.
aw_product_id,product_name,aw_deep_link,search_price,rrp_price,merchant_id,merchant_name,aw_image_url,aw_thumb_url,merchant_image_url,category_name,merchant_category,brand_name,model_number,currency,delivery_time,in_stock,promotional_text,specifications
10001,Brother Innov-is A16 Sewing Machine,https://www.awin1.com/cread.php?awinmid=12345&awinaffid=67890&clickref=&p=https://example.com/brother-innov-is-a16,299.99,349.99,12345,Sewing Direct,https://example.com/images/brother-a16-large.jpg,https://example.com/images/brother-a16-thumb.jpg,https://example.com/images/brother-a16.jpg,Sewing Machines,Home & Garden > Crafts > Sewing,Brother,Innov-is A16,GBP,3-5 days,Y,Save £50 on this computerized machine!,LCD display|16 stitches|Automatic needle threader|Free arm
10002,Janome 2212 Sewing Machine,https://www.awin1.com/cread.php?awinmid=12345&awinaffid=67890&clickref=&p=https://example.com/janome-2212,189.99,219.99,12345,Sewing Direct,https://example.com/images/janome-2212-large.jpg,https://example.com/images/janome-