I currently have a couple of Python scripts that takes a csv file and modifies the data and writes it to a new csv file in a TAB delimited format that I need some changes to be made to. Please read this file carefully. I tried to include everything I needed done in this project description but some small changes/tweaks may need to be made during the process.
The scripts are attached to this project for reference.
[url removed, login to view] processes the main data file named [url removed, login to view]
[url removed, login to view] processes the inventory data file called inventory [url removed, login to view]
The new features I need added are.
Both scripts need to be able to read a txt file that contains a list of the item_no/Product_code’s that will be written to the output file. All other records will be ignored.
In ([url removed, login to view]) I need to be able to override certain product categories that are written to the output file using another txt file that would contain two fields per line (source Category, output category)
In ([url removed, login to view]) if the input record has a map_price set the in the output file the record map_price should be set to “Y” and the output list_price field should be set to the input value of map_price.
If no map_price is set in the input file then may_price in the output file should be set to “N” and list_price in the output file should be set to the input file value MSRP.
In ([url removed, login to view]) Right now it calculates the output file price value using this formula.
outrow['Price']=str(float(inrow['price'] or 0 )*1.10)
I need it to read a text file that would contain the product_code/item_no with the price override that should be written to the output file. If it’s not found in the text file it should just default to the formula above.
In ([url removed, login to view]) I need the map_price routines made in ([url removed, login to view]) duplicated the same way.
I need a second set of the above scripts to work a little differently.
Instead of only writing records based on the list of product codes, I need the opposite where it ignores records in the list. I also need a way to ignore records written to the output file based on the input file value ‘brand’ so certain brand products are not written.
I have a second input data file that I also need to process the same as the above methods.
I need a third version of [url removed, login to view] written to work with the data file [url removed, login to view] this file does not have a header that contains the record names though. Right now they are like this.
'Product code','Detailed image','Product name','Description','Price','map_price','Weight','Quantity','Manufacturer','Category'
The output file needs to be I the same format as the other data file and needs to have new static fileds added just like the [url removed, login to view] but like this.
13 freelancers are bidding on average $102 for this job
Dear Sir! I am an expert. Ready to start and finish within 2 days. My bid is for fast professional service exciting my customers. Please contact in PM if you have any questions. Best Regards, Zeke