En cours

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]

Compétences : PHP, MySQL, Architecture Logicielle, SQL, Programmation de bases de données

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) CASCO, United States

Nº du projet : #20949979

Décerné à:

riksubhraray

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(0 Commentaires)
0.0

33 freelance font une offre moyenne de $162 pour ce travail

TenStar718

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(261 Commentaires)
8.7
idragon712

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(83 Commentaires)
7.8
urmate

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(312 Commentaires)
7.0
oscworker

Hello. I can start immediately. Thanks, Vitaliy.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(113 Commentaires)
7.0
polarjin2017

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(149 Commentaires)
7.0
valor312

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(113 Commentaires)
6.5
fanninson45

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(26 Commentaires)
6.0
webgenius0322

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(47 Commentaires)
5.5
MobileKing1225

★★~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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(16 Commentaires)
5.2
phantom1222

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(19 Commentaires)
4.8
artem127

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(20 Commentaires)
4.7
AlexanderPGR

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(24 Commentaires)
5.0
prasy8

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(19 Commentaires)
5.4
Kane96419

****************** 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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(12 Commentaires)
4.0
sharktiger

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
4.5
gpnr2017

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(6 Commentaires)
3.9
yongan20151117

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)
3.6
tanishasharma

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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(8 Commentaires)
3.3
yingyin618

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
3.1
tsft

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(4 Commentaires)
3.1