Find Jobs
Hire Freelancers

Automated excel formula/functionality go generate a matrix of SKUs, Barcodes and product catalog

$30-250 USD

Lezárt
Kiadva ekkor: körülbelül 6 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
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 Objective: 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
Projektazonosító: 16425960

A projektről

18 ajánlat
Távolról teljesíthető projekt
Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
18 szabadúszó adott átlagosan $214 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Greeting, I have understood your Automated excel formula/functionality go generate a matrix of SKUs, Barcodes and product catalog task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, Software Architecture, Visual Basic
$250 USD 4 napon belül
4,9 (352 értékelés)
8,0
8,0
Felhasználó avatár
Hi, I am expert in Excel and VBA for Excel and like to handle your project and submit my bid for it. Regards, Iyad
$600 USD 12 napon belül
4,9 (44 értékelés)
7,5
7,5
Felhasználó avatár
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$200 USD 3 napon belül
4,9 (306 értékelés)
7,3
7,3
Felhasználó avatár
I'm an Excel expert. I read your requirements carefully and I confirm that I can do exactly what you need. If you want me to share some files with you, please contact me on chat. I cannot attach a file to this message or contact you first. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
$300 USD 5 napon belül
4,8 (217 értékelés)
7,2
7,2
Felhasználó avatár
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$34 USD 3 napon belül
4,7 (96 értékelés)
7,4
7,4
Felhasználó avatár
A proposal has not yet been provided
$500 USD 10 napon belül
5,0 (126 értékelés)
6,6
6,6
Felhasználó avatár
A proposal has not yet been provided
$150 USD 1 napon belül
4,7 (73 értékelés)
6,2
6,2
Felhasználó avatár
Dear client, I have read the description and can do the merging task for you. I will write VBA macros for that. Looking forward
$133 USD 3 napon belül
5,0 (9 értékelés)
4,1
4,1
Felhasználó avatár
Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.
$160 USD 4 napon belül
4,7 (15 értékelés)
3,1
3,1
Felhasználó avatár
hello. I have worked on excel databases analysis with formulas for more than 10 years. I am smart and reliable. I am new to this site and need to gain reviews so I will work for minimum cost. You will stay satisfied. I need to know all the details to tell the exact time. Hope to cooperate with you
$111 USD 3 napon belül
5,0 (1 értékelés)
1,0
1,0
Felhasználó avatár
A proposal has not yet been provided
$155 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I have worked with barcodes for over 15 years while I wrote software for the Natural Product industry. We took spreadsheets full of barcodes from 1000s of suppliers and converted them into electronic catalogs for our software. I am an expert working with all barcode types. I am also new to Freelancer so I am willing to work just for the opportunity to earn a great review.
$55 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

SWITZERLAND zászlója
Geneva, Switzerland
5,0
95
Fizetési mód hitelesítve
Tagság kezdete: febr. 5, 2008

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.