Case Study - Data Entry for Dock Seller Online Store in USA

Woocommerce
Platform

Commercial and
Industrial

Data Entry Requirements for Dock Online Store

Our client is a online seller in USA and dealer of Dock products. The online store provides thebest options of Dock products according to customer requirements. The company provide hugecollection of Ladders, Bombers, Lighting, Safety products and many more.

Our client is looking for an on-going ecommerceproduct data entry team for their online store catalog management projects. He requiredto collecting all product information and images from giving data sources and manufacturerwebsites.

Client Project Instructions as follows

I'm building out a new dock products online store in USA. I've got most of the framework done,categories created with images etc. This is WordPress and WooCommerce. I need data entry staffto go to the manufacturer's website and start grabbing the images and pdf files for eachproduct. You can use test site as a guide to which categories (and subsequent products underthose subcategories) we'll be using. I need you to gather the images, .pdf files. Then thosefile names (which match SKU's) need to be added to the master import spreadsheet. Then I need totake the pricing and shipping information from a couple spreadsheets and copy them over to themaster import spreadsheet as well. We'll also need to assign products to thecategories/subcategories in the master spreadsheet too. We're looking at around two thousandproducts to sell in my online store at begining. Could be more.

We'll also need to create attributes for most products giving basic dimensions, material used(steel, aluminum, stainless etc), color selection if offered in different colors etc - thesewill be used for filtering in the sidebar. It's mostly the dock ladders section and thoseproducts that will have a lot more attributes (Number of Steps, Top Step Height, DistanceBetween Steps, Overall Width, Inside Width, Length etc - I can send a list of attribute we'llneed to use for those products. Not all products will have a bunch of attributes.

I can provide the data sheets sent me with all product details, pricing spreadsheet so you canlook over it. What they sent me has every product they sell. I won't be selling everything sowe'll need to identify that in the spreadsheet as well and remove products we're not selling.

I'm shooting to launch this online store soon so we have a month and a half until launch. Pleaseshare your thoughts.

Key Requirements

1. Identification of product categories and subcategories and their allocation to applicableproducts on the master sheet
2. Collection of product images and PDFs
3. Identification of files and their allocation to applicable products on the master sheet
4. Pricing & shipping info updates to master sheet
5. Identification of New, Discontinued, No Longer products by referring to the price list.
6. Grouping of simple and variable products in reference to the provided product master file
7. Product data formatting as per WooCommerce Template
8. Creation of HTML code
9. Bulk Import files into the media library and import products into the store.

Challenges

During the course of the project, we had faced numerous challenges, including:

1. Main category and subcategory identification from a broad collection of products in thevendor site, and right product category allocation to the client store.
2. Collection and identification of files from a massive cluster of files downloaded.
3. Our client insisted on the usage of a plugin for the documents. However, the custom tabplugin usage for this purpose was challenging and time-consuming.

To complete the data entry project within the stipulated time, while ensuring all specificationswere adhered to, we took the following steps:

1. We have settled the broad category identification and allocation matter by assigning thetask to the pool of proficient staff.
2. We have decided to use specific tools for quick and largescale file identification, andmanagement.
3. We have decided to embrace the challenge of managing the documents with a plugin. For that,we decided to create HTML codes to upload the files solely by plugin manually with specifictools.
4. In addition, we also decided to manage the specifications tab along with the files tab withthe custom tab plugin.
5. We extracted the data and populated the excel spreadsheet within required time.

Intellect Outsource helped the online retailer for completing productmanagement successfully.

Result

The client was contented with the project output. Our successful execution of thisproject ensured that the client received a bulky traffic rush, along with other benefitssuch as:

1. Noticed a remarkable rise in sales along with traffic after the website was launched.
2. Able to manage all sections of the business with ease through our backing.
3. The client was so delighted with our after-launch support, and subsequently, he hired newdata entry staff for his Dock selling products online store catalog management projects.

Intellect Outsource has been providing our services since last 12 years in USA ecommercebusiness. Our data entry staffs highly talented in Woocommerce productdata entry and bulk ecommerce productupload services. For more project enquiry contact us. We ready to discuss with you soon