I gang

Custom program to manage CSV price files

I am looking for a custom program, preferable PHP and Mysql, to combine and prep price files from multiple suppliers into one database that can be updated and exported into the proper format for my POS and Inventory systems.

All the price files are CSV files. The headers all vary so I am looking to upload the file and have a form show up with all the headers (and maybe sample data) in drop downs that I can select for each of the columns in the database. I will need to merge multiple columns from the source file into one column in the database.

If the part number uploaded already exists in the database then the information should be updated. If not it should be added. A single source file may have both updates and new lines. There would be a few relational tables, such as supplier. The same item might be available from multiple suppliers, each with their own cost. And category which just needs to be from a defined set and would be set per upload file, not per line.

Some basic management would be great. Just a table/ spreadsheet layout that we can filter and search to update records. Nothing fancy.

The export function will need to create a file we can load into our POS and Inventory systems. In the POS system we just need one of each part with the available suppliers. The other confusing thing we need is superceded parts. The database will include every part available but in the POS we only want the latest parts with the superceded part numbers referenced in the notes section. We also need the barcodes listed in the current part number so if we scan an old part it will come up with the current part. There are a few more things like that. I will put together a small example of the source files and the required result.

Our POS also has a API that we may like to integrate with to add and update the price lists. If we track when a row was last updated then maybe we can just do incremental updates. Each item has an ID in the POS system initially I will have the file from the POS to start with. Simply if ID exists update, otherwise add.

Products /api/v1

index GET /products

Also supports search, pass a param named "sku" to search for a SKU, or pass a param named "query" to do a text search

category filter /products?category_id=123

show GET /products/:id

new GET /products/new (instructions)

create POST /products

update PUT /products/:id

update LocationQuantity (big chain inventory levels) PUT /products/:id/location_quantities (needs location_quantity_id & quantity params)

Valid Parameters:

product: :price_cost, :price_retail, :condition, :description, :maintain_stock,

:name, :quantity, :warranty, :sort_order, :reorder_at, :disabled, :taxable,

:product_category, :upc_code, :discount_percent, :warranty_template_id, :qb_item_id,

:vendor_id, :desired_stock_level, :price_wholesale, :notes, :tax_rate_id,

:physical_location, :serialized

The UI does not need to be fancy, basic functional elements. Its only used by me.

Here are examples of the price files that would be uploaded and how they are imported into the POS.

[login to view URL]

Evner: PHP, MySQL, Software Arkitektur, SQL, Programmering af database

Se mere: edit file csv, csv editor mac, csv editor online, rons csv editor crack, rons csv editor pro, rons csv editor, wordpress csv import custom fields, wordpress import csv to database, program compare csv file, custom program log, program compare csv files, custom design usb flash price, custom video player developer price, convert wmv files used cut dvd, program create csv access database, custom flash video player price, need custom program, custom program needed, program can read dbb files, forums can custom program monstercommerce

Om arbejdsgiveren:
( 0 bedømmelser ) CASCO, United States

Projekt ID: #20949979

Tildelt til:


I have implemented such requirements in web based ERP & CRM systems and therefore I can implement it properly. ​ I can start the work as soon as you approve me the same and submit the deliverables in agreed timeline w Flere

$89 USD in 2 dage
(0 bedømmelser)

33 freelancere byder i gennemsnit $162 på dette job


Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and Flere

$200 USD in 7 dage
(261 bedømmelser)

Hello. I have rich experience with Pos inventory system and managing CSV. I am very clear what you want and I have rich experience with some PHP framework and Mysql. If you can agree, i will build with Laravel php fram Flere

$140 USD in 7 dage
(83 bedømmelser)

Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and requ Flere

$250 USD in 10 dage
(312 bedømmelser)

Hello. I can start immediately. Thanks, Vitaliy.

$200 USD in 7 dage
(113 bedømmelser)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. Here are my working result in c# [login to view URL] h Flere

$155 USD in 3 dage
(149 bedømmelser)

VERY EASY FOR ME As you can see in my review, I've done similar with yours Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time Flere

$140 USD in 7 dage
(113 bedømmelser)

INTRODUCTION I can create your online software in PHP together with other specified business intelligence searches and lookup integrations. I am smart enough to take your business requirements and create database-driv Flere

$140 USD in 7 dage
(26 bedømmelser)

Hello After reading your description carefully, I have been very sure that I can complete the it I am going to make it with Laravel Framework I will wait you thanks

$140 USD in 7 dage
(47 bedømmelser)

★★~Hello~★★ I can kindly give you the perfect result on the time you want right away. Because, I am a Back-End expert with 8 years of rich experience. In the meantime, I already developed many websites with Joomla, Wor Flere

$140 USD in 7 dage
(16 bedømmelser)

Hello.. I have read your post very carefully and I have understood what you want. I am a 100% completion Developer. I have experience of development like this. As an experienced developer, I am sure I can handle your p Flere

$150 USD in 7 dage
(19 bedømmelser)

Hi, sir I have best skills and much experiences in PHP programming. I have already completed so much projects and get good reviews from employers. I am sure I can complete this project. If we have a chat, then we can m Flere

$140 USD in 7 dage
(20 bedømmelser)

Hi, there I have read your description carefully I am very interested in your project. I have PHP and MySQL skill and can work for this project anytime Please contact me and discuss Thanks for your regards.

$140 USD in 7 dage
(24 bedømmelser)

Hi there, I have checked your shared spreadsheets. I have few queries so need to discuss requirements in detail. First, what you referring as 'headers' I am Senior Software Developer having 10 years of experience provi Flere

$150 USD in 7 dage
(19 bedømmelser)

****************** Dear ********************* Thanks for your posting. My name is Ze S. I have read your proposal and understood what you are going to do. I am a member of a team for developing cloud solution and hav Flere

$250 USD in 7 dage
(12 bedømmelser)

Hi. I am very interested to your project and ready to start right now. I have read your project requirement carefully. I can meet your requirement Give me one chance to work for you, will sure give you 101% high quali Flere

$200 USD in 3 dage
(19 bedømmelser)

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project. I will be using .net, c# and winform applicaiton tools to develop this application Flere

$130 USD in 7 dage
(6 bedømmelser)

Hello Sir I am web developer . I can development web application using php,python,java and html,javascript, mysql ,oracle. You can choose whatever you like. please contact me. Thank you.

$250 USD in 3 dage
(7 bedømmelser)

Greetings! I am 10 years of experienced developer, understanding requirements better and delivering better solution My Wordpress,woocomerce work- [login to view URL] [login to view URL] [login to view URL] Flere

$140 USD in 7 dage
(8 bedømmelser)

Dear ,sir. I have carefully read your job description with great interests and have noticed that your project requirements are in perfect match with my skills and expertise. I have experience in importing and exporti Flere

$140 USD in 2 dage
(2 bedømmelser)

Dear Sir or Madam: I am an expert programmer, working with a CSV and any format, ETL of any kind, conversionand automation with mutiples ways according to your syste, I am interested in doing the job. ASAP guaranteed Flere

$170 USD in 10 dage
(4 bedømmelser)