Modify CSV file from supplier for Magento 2 import

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

I have a pricefeed that I get daily from my supplier, which I need to manipulate in order to import in to magento once a day.

Reordering of the columns/data

Price calculation. example: =(MarketPrice/,85)+(Volume*600) where MarketPrice and Volume are specified in the csv file.

Extract first word from a field. example: Bosch WAN240A7SN. I need to extract the word Bosch to a seperate field, to import as manufacturer attribute.

As the categories in magento are nested in subcategories, I have a seperate list which defines the correct categories.

I would like to define the price calculation parameters in a seperate text file, which I can adjust if necessary.

I have attached supplier example file, magento import example file and the category lookup table.

Data Processing Excel Magento PHP Python

Project ID: #18494407

About the project

38 proposals Remote project Active 5 years ago

38 freelancers are bidding on average $153 for this job

ramzitra

Hi, I am interested in your project related to build a script that convert supplier CSV into magento one with some adjustments. Please send me a message so that we can discuss all the details. Thanks, Ramzi

$250 USD in 3 days
(521 Reviews)
8.6
schoudhary1553

Hello, I have gone through your job Modify CSV file from supplier for Magento 2 import and i am sure i can deliver you the quality job. Please see my profile i have deliver almost 430 projects with 100% client satis More

$180 USD in 3 days
(505 Reviews)
8.4
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. According to your brief, you want to have a tool in Excel to transform one format to another. I will use a macro More

$180 USD in 2 days
(343 Reviews)
8.0
hardikmemagara

Hello, I will complete your every requirement as per your need that you have mentioned in your job details. We are group of magento experts. Will support after the work done as well. so please Come to the discussio More

$250 USD in 5 days
(629 Reviews)
8.0
tiaratechies

Hello, working on different kinds of ecommerce stores, I have gained lot of experience in creating the files according to the provider needs, I can give you perfect format and make it workable.

$300 USD in 3 days
(116 Reviews)
7.6
mascotindia123

Hello there I have gone through your project detail, you want to modify CSV file from supplier for Magento 2 , i am import i am expert in magento 2 web development, provide you good communication and services More

$170 USD in 4 days
(284 Reviews)
7.7
lkhelladi

Hello, I'd be glad to build a Python tool that automates the csv file processing for you. Looking forward to chat with you soon for more details. Best regards,

$111 USD in 2 days
(185 Reviews)
7.5
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$180 USD in 3 days
(217 Reviews)
7.5
ambientinfotech

Dear Client, I have analyse your job details and you need to Modify CSV file from supplier for Magento 2 import. I am expert self-motivated and hardworking Magento developer having 8+ year experienced for both v More

$172 USD in 3 days
(339 Reviews)
7.6
devi222

Hi Sir, I am expert in Magneto product upload(Simple & Variable). I can maodify the supplier sheets or xml feeds to ready for import into magneto via csv by changing the prices based on percentage or whatever the fo More

$100 USD in 2 days
(205 Reviews)
7.2
branislavm

Hi, This is easy (OK, relatively easy) to do with MS Access. If you are for this idea, here is my offer! Regards, Branislav Mihaljev

$222 USD in 3 days
(273 Reviews)
7.1
rkmomin

Hello I have read the project details. I can do this job. please contact me on chat for further discussion. thanks

$150 USD in 7 days
(166 Reviews)
7.1
glennwilkins

sir message i can create script for this csv modifier for magento import .... sir message i can create script for this csv modifier for magento import ....

$100 USD in 0 days
(178 Reviews)
6.3
crystalhitesh

Dear Client, Greetings!! I am an expert level, self motivated, Magento 1&2 developer having 8+ years of experience in design & custom theme & custom module development, working on both version 1. x to 2. x. All t More

$97 USD in 3 days
(152 Reviews)
6.7
macroPOL

Hello, I am Excel and VBA expert. I have seen the files. I understand the requirements. I can do it in VBA (Excel VBA macros). If you have any questions, I will be happy to answer. Please note that I have 100 More

$125 USD in 3 days
(94 Reviews)
6.1
ChernenkoEgor

Higher-quality and faster-delivery is promised. Your job seems to be posted only for me not for the others, because you are looking for only an expert just like me. I have lived with P H P for +6 years so I know it a More

$250 USD in 3 days
(24 Reviews)
5.5
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. with thanks and regards Relevant Skills and Experience Excel, php

$194 USD in 3 days
(82 Reviews)
6.2
Mokshith30

hii i am vba developer experianced in vba macros & web scraping i will finish this task in a day only thanks

$66 USD in 0 days
(53 Reviews)
5.2
rlo56467a9097547

Hello there ! i can do this script if you want Contact me !

$98 USD in 0 days
(62 Reviews)
5.3
HuangTiger

Hello I'm a senior Magento developer who have 5+ years of experiences. Especially I've lots of experiences on custom extension such as product import feed. Please discuss more detail about your projects. Kind regar More

$155 USD in 3 days
(21 Reviews)
5.1