{"id":17010,"date":"2020-04-19T06:43:44","date_gmt":"2020-04-19T10:43:44","guid":{"rendered":"https:\/\/bangla.salearningschool.com\/recent-posts\/python-ecommerce-part-9-incorporate-images-in-your-magento-2-product-upload-file\/"},"modified":"2020-04-19T15:05:22","modified_gmt":"2020-04-19T19:05:22","slug":"python-ecommerce-part-9-incorporate-images-in-your-magento-2-product-upload-file","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=17010","title":{"rendered":"Python: Ecommerce: Part \u2014 9: Incorporate Images in your Magento 2 product Upload File"},"content":{"rendered":"
\n
\n
\n
\n
\n
\u00a0<\/div>\n
\n
\n
\n
8112223 Canada Inc. (Justetc)<\/a><\/div>\n
\n
\n
\n
\u00a0<\/div>\n<\/div>\n<\/div>\n
Apr 19<\/a>\u00a0\u00b7\u00a03\u00a0min read<\/div>\n<\/div>\n<\/div>\n
\n
\n
\u00a0<\/div>\n
\u00a0<\/div>\n
In [112]:<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
#magento_1_upload_file_with_image_urls_no_desc['<\/em><\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_1'] =<\/strong> raw_df['Additional Product Picture 1']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_2'] =<\/strong> raw_df['Additional Product Picture 2']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_3'] =<\/strong> raw_df['Additional Product Picture 3']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_4'] =<\/strong> raw_df['Additional Product Picture 4']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_5'] =<\/strong> raw_df['Additional Product Picture 5']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_6'] =<\/strong> raw_df['Additional Product Picture 6']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_7'] =<\/strong> raw_df['Additional Product Picture 7']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_8'] =<\/strong> raw_df['Additional Product Picture 8']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_9'] =<\/strong> raw_df['Additional Product Picture 9']<\/span>magento_2_upload_file_with_data_no_desc['gallery_image_url_10'] =<\/strong> raw_df['Additional Product Picture 10']<\/span>magento_2_upload_file_with_data_no_desc['image'] =<\/strong> raw_df['Main Product Picture']<\/span>magento_2_upload_file_with_data_no_desc['small_image'] =<\/strong> raw_df['Additional Product Picture 1']<\/span><\/pre>\n
In [113]:<\/p>\n
magento_2_upload_file_with_data_no_desc.head(2)<\/span><\/pre>\n
Out[113]:<\/p>\n
product_idskunameraw_pricecheapest_courier_shippingproduct_eanshopforsoul_profitebay_profitshopforsoul_costprice…gallery_image_url_4gallery_image_url_5gallery_image_url_6gallery_image_url_7gallery_image_url_8gallery_image_url_9gallery_image_url_10imagesmall_imageremote_image_url030399shopforsoul-A01AL3301111Black 3x3x3 MoYu AoLong V2 Puzzle-A01AL330111112.90500.06941377886603.0109.658109.658669.21778.87.<\/p>\n
2 rows \u00d7 76 columns<\/p>\n
In [114]:<\/p>\n
magento_2_upload_file_with_data_no_desc.to_csv(output_folder +<\/strong> 'images_all_to_upload_without_description_' +<\/strong> input_file_name +<\/strong> '_magento_2_' +<\/strong> today +<\/strong> '.csv',index=False<\/strong>, encoding=<\/strong>'utf8')<\/span><\/pre>\n
In [115]:<\/p>\n
Partition the data file into 20 partitions.<\/p>\n
partition =<\/strong> 20<\/span>increment =<\/strong>  int(round(magento_2_upload_file_with_data_no_desc.shape[0]\/<\/strong>partition,0)) +<\/strong> 1<\/span>increment<\/span>start =<\/strong> 0<\/span>for<\/strong> count in<\/strong> range(0, partition):<\/span>   start +=<\/strong> increment<\/span>   p =<\/strong> magento_2_upload_file_with_data_no_desc[start:start +<\/strong> increment]<\/span>   #print(p.head(1))<\/em><\/span>   p.to_csv(output_folder +<\/strong> 'partition-' +<\/strong> str(count) +<\/strong> '-image-magento2_all_to_upload_with_description_' +<\/strong> today +<\/strong> '.csv', index=False<\/strong>)<\/span><\/pre>\n
In [116]:<\/p>\n
df_new_template =<\/strong> pd.DataFrame()<\/span>df_new_template =<\/strong> pd.read_csv(template_folder +<\/strong> 'import-magento2-all-but-descriptions.csv')<\/span>df_new_template.head(1)<\/span><\/pre>\n
Out[116]:<\/p>\n
product_idskunameraw_pricedummycheapest_courier_shippingproduct_eanshopforsoul_profitebay_profitshopforsoul_cost…gallery_image_url_4gallery_image_url_5gallery_image_url_6gallery_image_url_7gallery_image_url_8gallery_image_url_9gallery_image_url_10imagesmall_imageremote_image_url028471ShopForSoul-PCO_004SZTH7OnePlus 7 Smartphone 12GB RAM 256GB ROM Snapdr…856.0350012.036941377796025182.82182.821097.21<\/p>\n
1 rows \u00d7 77 columns<\/p>\n
In [117]:<\/p>\n
magento_2_upload_file_with_data_no_desc.columns, df_new_template.columns<\/span><\/pre>\n
Out[117]:<\/p>\n
(Index(['product_id', 'sku', 'name', 'raw_price', 'cheapest_courier_shipping',
        'product_ean', 'shopforsoul_profit', 'ebay_profit', 'shopforsoul_cost',
        'price', 'special_price', 'special_from_date', 'special_to_date',
        'ebay_cost', 'ebay_list_price', 'amazon_profit', 'amazon_our_cost',
        'amazon_list_price', 'amazon_special_price', 'amazon_list_price_usd',
        'amazon_special_price_usd', 'amazon_list_price_gbp',
        'amazon_special_price_gbp', 'amazon_list_price_eu',
        'amazon_special_price_eu', 'weight', 'is_in_stock', 'categories',
        'visibility', 'height', 'width', 'length', 'status',
        'attribute_set_code', 'product_online', 'product_type',
        'product_websites', 'root_category', 'store_view_code',
        'tax_class_name', '_attribute_set', 'qty', 'min_qty',
        'use_config_min_qty', 'is_qty_decimal', 'backorders',
        'use_config_backorders', 'min_sale_qty', 'use_config_min_sale_qty',
        'max_sale_qty', 'use_config_max_sale_qty', 'notify_stock_qty',
        'use_config_notify_stock_qty', 'manage_stock',
        'use_config_manage_stock', 'stock_status_changed_auto',
        'use_config_qty_increments', 'qty_increments',
        'use_config_enable_qty_inc', 'enable_qty_increments',
        'is_decimal_divided', '_media_is_disabled', 'tax_class_id',
        'gallery_image_url_1', 'gallery_image_url_2', 'gallery_image_url_3',
        'gallery_image_url_4', 'gallery_image_url_5', 'gallery_image_url_6',
        'gallery_image_url_7', 'gallery_image_url_8', 'gallery_image_url_9',
        'gallery_image_url_10', 'image', 'small_image', 'remote_image_url'],
       dtype='object'),
 Index(['product_id', 'sku', 'name', 'raw_price', 'dummy',
        'cheapest_courier_shipping', 'product_ean', 'shopforsoul_profit',
        'ebay_profit', 'shopforsoul_cost', 'price', 'special_price',
        'special_from_date', 'special_to_date', 'ebay_cost', 'ebay_list_price',
        'amazon_profit', 'amazon_our_cost', 'amazon_list_price',
        'amazon_special_price', 'amazon_list_price_usd',
        'amazon_special_price_usd', 'amazon_list_price_gbp',
        'amazon_special_price_gbp', 'amazon_list_price_eu',
        'amazon_special_price_eu', 'weight', 'is_in_stock', 'categories',
        'root_category', 'visibility', 'height', 'width', 'length', 'status',
        'product_type', '_attribute_set', 'qty', 'min_qty',
        'use_config_min_qty', 'is_qty_decimal', 'backorders',
        'use_config_backorders', 'min_sale_qty', 'use_config_min_sale_qty',
        'max_sale_qty', 'use_config_max_sale_qty', 'notify_stock_qty',
        'use_config_notify_stock_qty', 'manage_stock',
        'use_config_manage_stock', 'stock_status_changed_auto',
        'use_config_qty_increments', 'qty_increments',
        'use_config_enable_qty_inc', 'enable_qty_increments',
        'is_decimal_divided', '_media_is_disabled', 'tax_class_id',
        'tax_class_name', 'store_view_code', 'attribute_set_code',
        'product_websites', 'product_online', 'gallery_image_url_1',
        'gallery_image_url_2', 'gallery_image_url_3', 'gallery_image_url_4',
        'gallery_image_url_5', 'gallery_image_url_6', 'gallery_image_url_7',
        'gallery_image_url_8', 'gallery_image_url_9', 'gallery_image_url_10',
        'image', 'small_image', 'remote_image_url'],
       dtype='object'))<\/span><\/pre>\n
In [118]:<\/p>\n
set(df_new_template.columns).difference(set(magento_2_upload_file_with_data_no_desc))<\/span><\/pre>\n
Out[118]:<\/p>\n
{'dummy'}<\/span><\/pre>\n
In [119]:<\/p>\n
set(magento_2_upload_file_with_data_no_desc ).difference(set(df_new_template.columns))<\/span><\/pre>\n
Out[119]:<\/p>\n
set()<\/span><\/pre>\n
\u2014 \u2014 \u2014 \u2014 \u2014 \u2014 \u2014 \u2014 \u2014 \u2014 –<\/p>\n
All code in one block.<\/p>\n
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_1\u2019] = raw_df[\u2018Additional Product Picture 1\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_2\u2019] = raw_df[\u2018Additional Product Picture 2\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_3\u2019] = raw_df[\u2018Additional Product Picture 3\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_4\u2019] = raw_df[\u2018Additional Product Picture 4\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_5\u2019] = raw_df[\u2018Additional Product Picture 5\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_6\u2019] = raw_df[\u2018Additional Product Picture 6\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_7\u2019] = raw_df[\u2018Additional Product Picture 7\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_8\u2019] = raw_df[\u2018Additional Product Picture 8\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_9\u2019] = raw_df[\u2018Additional Product Picture 9\u2019]
magento_2_upload_file_with_data_no_desc[\u2018gallery_image_url_10\u2019] = raw_df[\u2018Additional Product Picture 10\u2019]
magento_2_upload_file_with_data_no_desc[\u2018image\u2019] = raw_df[\u2018Main Product Picture\u2019]
magento_2_upload_file_with_data_no_desc[\u2018small_image\u2019] = raw_df[\u2018Additional Product Picture 1\u2019]
magento_2_upload_file_with_data_no_desc[\u2018remote_image_url\u2019] = raw_df[\u2018Main Product Picture\u2019]<\/span># In[ ]:<\/span>magento_2_upload_file_with_data_no_desc.head(2)<\/span># In[ ]:<\/span>magento_2_upload_file_with_data_no_desc.to_csv(output_folder + \u2018images_all_to_upload_without_description_\u2019 + input_file_name + \u2018_magento_2_\u2019 + today + \u2018.csv\u2019,index=False, encoding=\u2019utf8')<\/span># In[ ]:<\/span>partition = 20
increment = int(round(magento_2_upload_file_with_data_no_desc.shape[0]\/partition,0)) + 1
increment<\/span>start = 0 
for count in range(0, partition):
 start += increment
 p = magento_2_upload_file_with_data_no_desc[start:start + increment]
 #print(p.head(1))
 p.to_csv(output_folder + \u2018partition-\u2019 + str(count) + \u2018-image-magento2_all_to_upload_with_description_\u2019 + today + \u2018.csv\u2019, index=False)<\/span># In[ ]:<\/span>df_new_template = pd.DataFrame()
df_new_template = pd.read_csv(template_folder + \u2018import-magento2-all-but-descriptions.csv\u2019)
df_new_template.head(1)<\/span># In[ ]:<\/span>magento_2_upload_file_with_data_no_desc.columns, df_new_template.columns<\/span># In[ ]:<\/span>set(df_new_template.columns).difference(set(magento_2_upload_file_with_data_no_desc))<\/span># In[ ]:<\/span>set(magento_2_upload_file_with_data_no_desc ).difference(set(df_new_template.columns))<\/span># In[ ]:<\/span><\/pre>\n
Medium:\u00a0<\/em><\/strong>https:\/\/medium.com\/@SayedAhmedCanada<\/a><\/p>\n
*** . *** *** . *** . *** . ***<\/p>\n
Sayed Ahmed<\/em><\/strong><\/p>\n
BSc. Eng. in Comp. Sc. & Eng. (BUET)<\/em><\/strong><\/p>\n
MSc. in Comp. Sc. (U of Manitoba, Canada)<\/em><\/strong><\/p>\n
MSc. in Data Science and Analytics (Ryerson University, Canada)<\/em><\/strong><\/p>\n
Linkedin<\/em><\/strong>:\u00a0<\/em>https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/em><\/a><\/p>\n
Blog<\/em><\/strong>:\u00a0<\/em>http:\/\/Bangla.SaLearningSchool.com<\/em><\/a>,\u00a0<\/em>http:\/\/SitesTree.com<\/em><\/a><\/p>\n
Training Courses:\u00a0<\/em><\/strong>http:\/\/Training.SitesTree.com<\/em><\/a><\/p>\n
8112223 Canada Inc\/Justetc<\/em><\/strong>:\u00a0<\/em>http:\/\/JustEtc.net<\/em><\/a><\/p>\n
Facebook Groups\/Forums to discuss (Q & A):<\/em><\/strong><\/p>\n
https:\/\/www.facebook.com\/banglasalearningschool<\/a><\/p>\n
https:\/\/www.facebook.com\/justetcsocial<\/a><\/p>\n
Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others.\u00a0<\/em>http:\/\/sitestree.com\/training\/
<\/a><\/p>\n<\/div>\n<\/div>\n<\/section>\n<\/article>\n
\n
\n
\n
\n
\n
\n
Build Ecommerce Software and Systems<\/h2>\n
\n
Build Ecommerce Software and Systems<\/h4>\n<\/div>\n