We have few excel files perforning each one of them a different role:
1- SKU generator: This excel file allows a user to specify the different brands/types/variations of their products and assist in assigning acronyms to each value in order to generate a short but semantic SKU
2- EAN13 bardode generator: This excel file uses a table or list of existing SKUs and generates EAN13 compatible barcodes and allocate them to each SKU (importance of unique pairs between SKU and barcode to avoid duplicates in inventory). An EAN font is required and attached for this excel to work.
3- Excel product catalog: Here the idea is to have the equivalent of a simple database of products with product name, SKU, barcode, description and images
A- Combine all functionalities into one document
B- For the SKU part, once the user enters all variations and their values, the file should generate automatically all the possible combinations of variants and create their SKU. For instance if we have a product available in 3 models, 3 colors and 3 sizes then this excel should generate the 27 different possible combination with each one its SKU allocated.
C- In addition to the table/matrix with all the possible combination the system should generate and assign an EAN13 barcode to each SKU.
D- The product catalog sheet should be used as a model to allow the user to assign an image to each product and assign a description
E- The excel file should provide an option to print a label for each SKU (with product name, SKU, barcode) using the printing template of a given brand of address labels (Avery)
F- The excel file should provide an option to print the whole catalog of products in a way that looks like an e-commerce catalog
The excel file need to be able to run on old computers with old version of windows as this aimed to users in developing countries and remote and poor locations
Please see attached all the pieces of excel and files we have and we are available for more details
The ultimate objective is to use these excel files to conduct local training on how to build a catalog for e-commerce even without internet and then take these files to a location where there is internet and upload the catalog on an e-commerce solution like magento or prestashop
So we need this excel file to also be able to generate a csv file type that could be used to upload this on an ecommerce/CMS system.
You can give instruction on how images should be saved or named and in which folder in order for the excel > to web part to work
suggestions are welcome or existing available working solutions are acceptable
thank you in advance
Please demonstrate your excel/visual basics skills by sharing excel documents you have done that perform complex operations/functionalities similar to what we have asked