keepingbusy
Programmer
Hi
I have set up a website using oscommerce and all is working perfectly. One of the tables is called products and a field within that is called WEIGHT. This particular field is a VARCHAR(15) and at present is populated by a UPC/SKU number via uploading CSV files via phpmyadmin to reflect on titles on the website.
There is also another table called orders_products[b/]. I have looked at this table which is quite limited in the amount of fields it has so I added one called WEIGHT being the same as the field in the products table.
The reason for this question is, when we check our orders the UPC/SKU number will be shown on the customers order, we just copy and paste this into a Visual FoxPro app we have and this in turn creates an order to the supplier. We have been using barcode scanners to speed up the process with our procedures, hence the effort to do the same with this one.
Explanation out of the way....
Can someone please advise how to get the information from the products field WEIGHT and into the orders_products table at the time of ordering? I have posted this same question on the oscommerce forum but without reply.
I have managed to create, amend and do some updates to our site purely by research but will admit that I'm not an expert in php (but willing to give it a go).
If someone could just direct or advise me I would be grateful
Many thanks
Lee
Windows XP
Visual FoxPro Version 6 & 9
I have set up a website using oscommerce and all is working perfectly. One of the tables is called products and a field within that is called WEIGHT. This particular field is a VARCHAR(15) and at present is populated by a UPC/SKU number via uploading CSV files via phpmyadmin to reflect on titles on the website.
There is also another table called orders_products[b/]. I have looked at this table which is quite limited in the amount of fields it has so I added one called WEIGHT being the same as the field in the products table.
The reason for this question is, when we check our orders the UPC/SKU number will be shown on the customers order, we just copy and paste this into a Visual FoxPro app we have and this in turn creates an order to the supplier. We have been using barcode scanners to speed up the process with our procedures, hence the effort to do the same with this one.
Explanation out of the way....
Can someone please advise how to get the information from the products field WEIGHT and into the orders_products table at the time of ordering? I have posted this same question on the oscommerce forum but without reply.
I have managed to create, amend and do some updates to our site purely by research but will admit that I'm not an expert in php (but willing to give it a go).
If someone could just direct or advise me I would be grateful
Many thanks
Lee
Windows XP
Visual FoxPro Version 6 & 9
