Sedang Disiapkan

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]

Kemahiran: PHP, MySQL, Kejuruteraan Perisian, SQL, Pengaturcaraan Pangkalan Data

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) CASCO, United States

ID Projek: #20949979

Dianugerahkan kepada:

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 Lagi

$89 USD dalam 2 hari
(3 Ulasan)
0.0

33 pekerja bebas membida secara purata $162 untuk pekerjaan ini

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 Lagi

$200 USD dalam 7 hari
(262 Ulasan)
8.8
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 Lagi

$140 USD dalam 7 hari
(83 Ulasan)
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 Lagi

$250 USD dalam 10 hari
(315 Ulasan)
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 Lagi

$155 USD dalam 3 hari
(150 Ulasan)
7.1
oscworker

Hello. I can start immediately. Thanks, Vitaliy.

$200 USD dalam 7 hari
(113 Ulasan)
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 Lagi

$140 USD dalam 7 hari
(119 Ulasan)
6.6
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 Lagi

$140 USD dalam 7 hari
(28 Ulasan)
6.1
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

$140 USD dalam 7 hari
(49 Ulasan)
5.6
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 Lagi

$140 USD dalam 7 hari
(18 Ulasan)
5.4
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.

$140 USD dalam 7 hari
(28 Ulasan)
5.2
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 Lagi

$140 USD dalam 7 hari
(23 Ulasan)
4.8
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 Lagi

$150 USD dalam 7 hari
(21 Ulasan)
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 Lagi

$150 USD dalam 7 hari
(19 Ulasan)
5.4
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 Lagi

$200 USD dalam 3 hari
(23 Ulasan)
4.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.

$250 USD dalam 3 hari
(7 Ulasan)
3.7
WongGanteng

Dear client. I read your description carefully. CSV data mining with php & mysql. I can complete your project successfully. Thanks.

$140 USD dalam 7 hari
(4 Ulasan)
3.8
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 Lagi

$250 USD dalam 7 hari
(12 Ulasan)
4.0
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 Lagi

$130 USD dalam 7 hari
(6 Ulasan)
3.9
michaels225

Hi, sir. How are you? Thank you for your job posting. I've just read your project carefully. As a full-stack developer, I have enough experience with PHP, Javascript, ASP.NET, Nodejs, React.js, Laravel of 5+ years. I Lagi

$140 USD dalam 7 hari
(9 Ulasan)
3.8
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] Lagi

$140 USD dalam 7 hari
(8 Ulasan)
3.3