The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Data Entry: 500-Product Data Entry and Exel Cleanup for Online store.
Problem i solved: Online store product data scattered across invoices, WhatsApp messages and photos. Needed in one clean Exel sheet.
What i did
1. Entered 500 products: Name, SKU, Price, Description, Stock
2. Cleaned duplicates, Fixed spelling errors, Standardized formatting
3. Created dropdown filters, conditional formatting for low stock
4. Added formulas for total inventory value and profit margin.
100% accurate sheet delivered in 2 days. Client can now upload directly to Shopify.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Self-Created Practice Project
I worked on a practice hotel booking dataset where multiple data fields were combined into a single raw-data column.
Work completed:
Separated unstructured data into individual columns using Text to Columns
Organized Booking ID, Guest Name, City, Check-In Date, Check-Out Date, Number of Pax, Amount and Status
Improved the structure and readability of the spreadsheet
Prepared the dataset for easier filtering and further use
Tool: Microsoft Excel
Skills: Data Entry | Data Cleaning | Text to Columns | Data Organization | Spreadsheet Formatting
This is a self-created practice project and not client work
I Created Microsoft Power BI Dashboard By using many of the Tools
🚀 Data Modelling
🧠 Data Visualization
🚀 Group By
🧠 Data Cleaning
Two orders. Three line items. Four units.
A repeated order ID isn't enough to decide which row to delete.
In this fictional example:
• Order 9001: one mug at $10, plus two teas at $10 each. Order total: $30.
• Order 9002: one book at $12. Order total: $12.
That's two orders, three line items and four units, with $42 in order totals. Deleting the tea row because 9001 appears twice loses a legitimate item. Copying the $30 order total onto both item rows and summing that column produces $72 instead of $42.
Keep the item-level view intact. Build a separate order summary with each verified order-level amount recorded once, and flag conflicting values for review.
Self-initiated, AI-assisted teaching sample with checked arithmetic. One currency; no shipping, discounts, taxes or refunds. These simplified rows are not an untouched Shopify export, and no live Shopify integration was tested.
Shopify documents why additional line items occupy separate rows:
https://help.shopify.com/en/manual/fulfillment/managing-orders/exporting-orders
I'm testing a $250 offline catalog/export preparation pilot: supplied mapping rules, a cleaned table, exceptions and reconciliation. If that fits a small agency task, message me here with a short non-sensitive description. Scope, data handling and timing would be agreed before starting.