Https://veles-concierge.com/
Technical Assignment
Title:
“Bringing Excel files of different brands into a unified structure + bulk import of products into WooCommerce”
Task Description:
We are launching a jewelry section on the website. We have a folder with ~4000 products from various brands (Cartier, Boucheron, Graff, etc.). Each brand is represented by an Excel file or an archive, but the column structures of different brands differ (different column names, necessary fields may be missing, different sorting).
Requirements:
Create a script or process that:
reads all Excel/CSV files,
aligns them to a unified column template: Name, Description, Regular price, Images, Category, Brand, (optional) Attributes (Material, Gemstone, Size),
transforms the data (removes the € sign, changes comma to dot, processes multiple image URLs through a separator),
Create CSV file(s) ready for import into WooCommerce/WP All Import — with the necessary headers and UTF-8 encoding, separator “,”
Set up the import template in WP All Import (Pro + WooCommerce Add-On) on the site:
mapping columns to WooCommerce fields: Title, Description, Regular Price, Images, Categories, Brand (Attribute), Attributes …
import products (new — not updating old ones) into the “Jewelry / Ювелирные изделия” section, with brand categories, subcategories (Rings, Earrings, Bracelets, etc.),
Check the upload: after importing 5-10 products manually, check the display on the site, categories, photos, prices, filters, then proceed with bulk upload.
Document with instructions on how to upload the next brand in the future (which file, where to place it, how to start the import) — so it can be “click and forget”.
Requirements for the Performer:
Experience with WooCommerce and WP All Import (preferably screenshots/portfolio)
Ability to work with bulk Excel/CSV data and scripting (Python/Google Sheets/Excel macros)
Responsibility, accuracy — we do not want the products to “fly away”
Deadline: no later than 7 days from the start.
Budget is negotiable; target — X USD (a range can be specified).
Result:
Ready CSV file or files, ready for import.
Officially configured import on the site, products uploaded.
Report and instructions — on how to further upload new files.
-
Winning proposal3 days215 USD
2536 51 1 Winning proposal3 days215 USDWhat I will do
1. Unification of sources
• Parser (Python) for reading all Excel/CSV/archives → reduction to a single column template:
Name, Description, Regular price, Images, Category, Brand, Attributes (Material; Gemstone; Size)
• Normalization: removing the "€" sign, replacing comma with dot, trim/cleanup HTML, parsing multiple image URLs (separator), deduplication.
• Agreed taxonomy: Jewelry → subcategories (Rings, Earrings, Bracelets, …) + Brand as an attribute/category (by agreement).
2. Ready files for import
…
• Export in UTF-8 CSV, separator ",", headers compatible with WP All Import.
• Splitting into batches (if necessary) for stable import of 4k+ items.
3. Import setup on the site
• WP All Import Pro + Woo Add-On: field mapping (Title, Description, Regular Price, Images, Categories, Brand, Attributes…).
• Mode for only new products, placement in the Jewelry section.
• Test import of 5–10 items → visual check (card, photo, price, filters) → bulk import.
4. Documentation + “click and forget”
• Short instruction: where to place the brand file, how to start processing/import.
• Optional: script shortcut in WP-CRON/CLI for repeated uploads.
-
2 days222 USD
475 2 0 2 days222 USDI will help to do it
It will take a couple of days
-
2 days215 USD
1328 6 0 2 days215 USDHello!!!
There is already a ready concept, the work was done according to the website parsing and alignment in columns, but I can correct it and do it for your project and save it in CSV and Excel. I have skills in Python and have done similar work, which is in my portfolio.
Feel free to reach out.
-
3 days213 USD
1641 23 0 3 days213 USDHello, I can solve your task with the help of AI. Over 5 years of development, a bunch of optimized business processes.
Write to me in private messages, I will offer solutions.