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]
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
33 freelance font une offre moyenne de $162 pour ce travail
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
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
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
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
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
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
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
★★~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
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
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
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.
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
****************** 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
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
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
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
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
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