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:

1. 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),

2. Create CSV file(s) ready for import into WooCommerce/WP All Import — with the necessary headers and UTF-8 encoding, separator “,”

3. 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.),

4. Check the upload: after importing 5-10 products manually, check the display on the site, categories, photos, prices, filters, then proceed with bulk upload.

5. 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.