Devam Ediyor

Consolidate CSV Price List Import/Export

XLS and CSV modification

Possible Languages:

• C (.NET)

• Visual Basic

• Python

• MS Access (2003/2007)

• MSSQL

Overview

We have an ecommerce site (future [url removed, login to view]) that requires daily price/product updates. We need a program or script (i.e. Excel or Access script/macro, etc) that will import data from CSV/XLS, consolidate the data, and export one table as CSV and another table as XLS (Excel 2003) format.

This script/macro/program needs to be run once daily (manual or scheduled)

File Formats

Import – Files to import will be in either CSV or XLS (Excel 2003) format.

Export – Data to export will be formatted in both CSV and XLS (Excel 2003) format.

Details

Import / Export

• Product/price lists (CSV and XLS) will be received daily and imported/consolidated into a master list.

• Imported Price lists will have different table headings and each supplier's list will need to be appropriately mapped into the master list

• All code must be documented to allow for minor changes (e.g. allow for addition of new suppliers with different data mapping)

• Export a copy of the master list as CSV, with custom table headings/format (so we can use our import tool to update MS Dynamics CRM product list)

• Export a copy of the master list as XLS (2003), with custom table headings/format (so we can upload/import to update online ecommerce product list)

Data Management

• Key index for the consolidated master list needs to be auto-generated, as we will have some overlap of the same product coming from different suppliers with different prices.

• We need the script to run a quick if/else switch so the export for the ecommerce database will update only one entry per product code as "active", the other entries of the same product as "inactive" - so that customers won't be confused when they search up a product and find many of the same item for different prices.

• The script must add a simple counter (can be table column) to keep track of number of days out of stock. Given that a product has seen 0 stock in over a given period (can be adjusted), to change the status of the product to "not active" so the ecommerce website will no longer display the product on the web site.

• We require an area where we can manually set the % markup rules (i.e. markupPrice= ceil(costPrice * [url removed, login to view], 1) thus a 10% mark up, minimum of 1 dollar. These rules need to be set up by category

• Exchange rate calculation. We require an area where we can manually input the exchange rate. Also to denote the currency for each supplier we work with.

Beceriler: .NET, Veri İşleme, Excel, Envanter Yönetimi, Microsoft Access

Daha fazlasını görün: export price list format, price list import export, supplier price list formats, consolidate csv, upload data consolidate, export price list excel, import price list csv, will price, web markup languages, web languages list, visual basic price, visual basic online tool, visual basic 2007 online, simple dollar, rate visual basic, python updates, python exchange, program website python, product supplier database, price file, online work website list, online visual basic 2010, online daily code, one dollar site, needs suppliers

İşveren Hakkında:
( 0 değerlendirme ) Markham, Canada

Proje NO: #700823

Seçilen:

Morphe

I am a Toronto boy who headed out West many years ago.I am a long time VB/MS Developer based on Vancouver Island. What you are asking for is very straightforward. If given the go ahead today you would have it by tomo Daha fazlası

1 gün içinde 225$ USD
(0 Değerlendirme)
0.0

28 freelancer bu iş için ortalamada 173$ teklif veriyor

vbexcel

Ten years experience in developing Excel/VBA based applications.

in 5 gün içinde190$ USD
(26 Değerlendirme)
5.3
BSoftTech

I've expertise in MS Access and .CSV files access and management. I can provide the solution you are looking for. Thanks, John

in 5 gün içinde250$ USD
(1 Değerlendirme)
3.1
rizwanfpak

Please check your PMB. Thanks

in 8 gün içinde200$ USD
(2 Değerlendirme)
2.7
ympaul

Hi I can do this with excellence. Please check my pmb. Thanks Paul

in 5 gün içinde140$ USD
(3 Değerlendirme)
2.3
JaPeL

Hello! please check PMB.

in 4 gün içinde150$ USD
(1 Değerlendirme)
1.5
anilohri

Hello sir, I am Software team lead and a technical writer with more than 9 yrs of software development experience. I can do this job easily and with 100% satisfaction for you. Let me know Thanks, Anil

in 10 gün içinde250$ USD
(0 Değerlendirme)
0.0
esttaq

We are experienced in providing software solutions to multinationals. We have enough expertise to complete your task as specified.

in 20 gün içinde150$ USD
(0 Değerlendirme)
0.0
al3adeyat

Hello Sir, We are Al3adeyat IT Integrated solution office having more than 9 years experience in the field of computer programming & IT in general. We believe that we can do the project effectively & in a very effic Daha fazlası

in 23 gün içinde220$ USD
(0 Değerlendirme)
0.0
billfan88

hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f Daha fazlası

in 3 gün içinde200$ USD
(0 Değerlendirme)
0.0
thecrmsolutions

Hello, Microsoft CRM Experts here. Please see PMB. Thanks!!!

in 7 gün içinde500$ USD
(1 Değerlendirme)
4.1
sheltonresearch

We have a basic structure for that - see details.

in 2 gün içinde200$ USD
(0 Değerlendirme)
0.0
eliteinfotech

Please check your PMB Thank you www.theeliteinfotech.com

in 12 gün içinde150$ USD
(0 Değerlendirme)
0.0
beep2012001

Hello, I have advanced knowledge in this area and have created a similar program for another company. I would love the opportunity to complete this project. P lease pm me to talk.

in 5 gün içinde125$ USD
(0 Değerlendirme)
0.0
mhlakhani

I'm experienced with this sort of stuff and will give you a python-based solution. Please check your PMB for details. Ready to start quickly!

in 7 gün içinde200$ USD
(0 Değerlendirme)
0.0
kricha1985

currently we're doing projects for import/export excel and csv files for payroll. we can provide efficient solution for this.

in 30 gün içinde225$ USD
(0 Değerlendirme)
0.0
mysilversir

We are doing since 2004. if you need to be confirm, i can send you screen shorts about my work. I am a team to work with desktop with .net and mysql. hope we will talk soon. bye. rk

in 15 gün içinde155$ USD
(0 Değerlendirme)
0.0
kushalumarkar

Dear Sir, I have experience of various database ripping mysql,access,binary files, csv files,encrypted binary file. Please pmb me with sound data to see my work. Regards

in 2 gün içinde75$ USD
(0 Değerlendirme)
0.0
manoj25285

Hi, I am interested to work on this project . I messaged you more details,Please check your PMB. Thanks, Manoj.

in 3 gün içinde150$ USD
(0 Değerlendirme)
0.0
neha13

please see PMB

in 7 gün içinde100$ USD
(0 Değerlendirme)
0.0
Nadirkhan

Well i have experience in inventory managment and software development i have also worked with retail pro, SAP MS RMS I can fullfill what you need

in 7 gün içinde30$ USD
(0 Değerlendirme)
0.0