Electronics Catalog Attribute Sorting
Budget: ₹100 – ₹400 INR
I have an electronics catalogue that’s grown messy over time and I want it reorganised so every product is easy to find and filter. The store’s core identifiers are Part Number, SKU and Price, and others, so those three columns must be rock-solid. In addition, I’d like to bring together the other data we already hold—size, package type, capacitance, brand and any related specs—so the entire listing follows a single, consistent structure.
Here’s what I need from you:
• Clean the raw export (CSV, Excel or Google Sheet—whichever you prefer) and normalise spelling, capitalisation and units where they differ.
• Re-arrange and, where missing, create the columns for Part Number, SKU, Price, Size, Package, Capacitance and Brand, keeping all existing product descriptions intact.
• Make sure prices stay in the original currency and number format.
• Deliver a final spreadsheet that sorts first by Part Number, then by SKU, and finally by ascending Price so the file is ready for a straightforward import back into my e-commerce platform.
I’ll share the current product file in doc format as soon as we start; it has roughly a few hundred rows. i need excel file for this arranged products.
Here’s what I need from you:
• Clean the raw export (CSV, Excel or Google Sheet—whichever you prefer) and normalise spelling, capitalisation and units where they differ.
• Re-arrange and, where missing, create the columns for Part Number, SKU, Price, Size, Package, Capacitance and Brand, keeping all existing product descriptions intact.
• Make sure prices stay in the original currency and number format.
• Deliver a final spreadsheet that sorts first by Part Number, then by SKU, and finally by ascending Price so the file is ready for a straightforward import back into my e-commerce platform.
I’ll share the current product file in doc format as soon as we start; it has roughly a few hundred rows. i need excel file for this arranged products.