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.
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)
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,
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]
33 freelancere byder i gennemsnit $162 på dette job
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
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.