Category: ব্লগ । Blog

ব্লগ । Blog

Python: Ecommerce: Part — 6: Format and adjust your product data and price data to save to a csv to upload to Magento 2.

Code will be given cell by cell from Jupyter Notebook. Then will also give all code in one block. You might need to adjust the indenting a bit. Read the code comments as well. Comments explained the sections. In [86]: # calculate/adjust data so that we can create magento 2 upload files # csv file …

Continue reading

Python: Ecommerce: Part — 5: Calculate Your Sell Prices for Ebay and Amazon

Please read the other articles for this series. Code will be given cell by cell from Jupyter Notebook. Then will also give all code in one block. You might need to adjust the indenting a bit. Read the code comments as well. Comments explained the sections. Calculate sell prices (and related) for ebay In [46]: …

Continue reading

Python: Ecommerce: Part — 4: Calculate Your Sell Prices for your Retail Website, and then calculate for Amazon and Ebay

The requirements for each of the sales channel can be different such as for Ebay you might want to calculate Paypal fees; for Amazon you have to check for Amazon fees. For your own retail site, shipping cost might need different calculation as well as based on your target audience tax/hst will affect the price. …

Continue reading

Python: Ecommerce: Part — 3: Remove Unwanted Category (and Products), Also, remove products based on Words in the Title — after Merging All Supplier Data Files into One File

You could as well remove products that are not allowed in a country or in a market place as well as products that you are not authorized to sell (some brands) All Code in One Block. Please check the other parts of this series/publication The code could be simplified/reduced. You could join multiple blocks into …

Continue reading

Python: Ecommerce: Part — 2: Drop Duplicates, Sort, and Take Only Unique Products After Merging All Supplier D ata Files into One File

All code in One Block # # Section: Verify, and Process Supplier Data Before Sending products to # # your retail (Magento 2) or marketplace (Amazon, Walmart)# In[7]:# combined_csv.sort_values(“Model Code”, inplace = True) # dropping ALL duplicte values based on Product SKU = Model Codeno_duplicates_combined_csv = combined_csv.drop_duplicates(subset = “Model Code”, keep = False, inplace = …

Continue reading

Python: Ecommerce: Part — 1: Merge Multiple Supplier Data Files into One File

Section: Merge multiple Supplier Data Files All code in one block #!/usr/bin/env python # coding: utf-8# # Section: Merge multiple Supplier Data Files ## In[1]:# if there is a need to merge multiple files — use this block import os; import glob; import pandas as pd;# supplier data files/feeds are kept here data_folder = ‘data-supplier-2019–04–14/supplier-raw-data/’; …

Continue reading

Python: Ecommerce: Part — 1: Merge Multiple Supplier Data Files into One File

Python: Ecommerce: Part — 1: Merge Multiple Supplier Data Files into One File Section: Merge multiple Supplier Data Files All code in one block #!/usr/bin/env python # coding: utf-8 # # Section: Merge multiple Supplier Data Files # # In[1]: # if there is a need to merge multiple files — use this block import os; import …

Continue reading

Python: Ecommerce: Part — 3: Remove Unwanted Category (and Products), Also, remove products based on Words in the Title — after Merging All Supplier Data Files into One File

Python: Ecommerce: Part — 3: Remove Unwanted Category (and Products), Also, remove products based on Words in the Title — after Merging All Supplier Data Files into One File Python: Ecommerce: Part — 3: Remove Unwanted Category (and Products), Also, remove products based on Words in the Title — after Merging All Supplier Data Files into One File. You could as well remove …

Continue reading

Modeling and Optimization : Gurobi, Cplex in addition to Matlab

Modeling and Optimization : Gurobi, Cplex in addition to Matlab Python in general can be a better choice for Gurobi, and CPlex. Gurobi works with Matlab as well. You can develop Gurobi applications in Anaconda, and Jupyter. GUROBI OPTIMIZER QUICK START GUIDE https://www.gurobi.com/wp-content/plugins/hd_documentations/content/pdf/quickstart_linux_8.1.pdf Starting with CPLEX https://www.ibm.com/support/knowledgecenter/SSSA5P_12.7.1/ilog.odms.studio.help/Optimization_Studio/topics/COS_home.html https://www.ibm.com/support/knowledgecenter/SSSA5P_12.7.1/ilog.odms.cplex.help/CPLEX/GettingStarted/topics/set_up/Python_setup.html Gurobi: Reference manual https://www.gurobi.com/documentation/8.1/refman/index.html Gurobi Optimizer Example …

Continue reading

Gurobi: Optimization: Learn from Examples

Gurobi: Optimization: Learn from Examples View the modeling examples: Cell Tower Coverage Customer Assignment Facility Location HP Williams Modeling Examples L0-Regression Offshore Wind Farming Standard Pooling Traveling Salesman ***. ***. *** Note: Older short-notes from this site are posted on Medium: https://medium.com/@SayedAhmedCanada *** . *** *** . *** . *** . *** Sayed Ahmed BSc. …

Continue reading