I have set my site up and have a number of products but the supplier works on barcodes for ordering. At the moment i am downloading the orders in Excel and then running a Macro over the order to lookup a barcode from a "Master Sheet" and inserting it.
My question is...
I have a product with attributes of Size and Colour - but each size/colour variation requires a different barcode (EAN13) can a barcode be assigned somewhere so i can pull the report off the database including the barcode? Basically i want the barcode to never be visible to the customer in the front end but it is somehow linked in the database tables.
This way i can use the SQL to Excel component I am currently using to download the orders and include the barcode also.
If this can be done as the system is please can someone tell me how. If not is this something someone is willing to make as a mod?