eCommerce Store : Vendor to Store mapping for Bulk Upload
- Required 50+ vendor files to be mapped to the bigCommerce template for bulk uploading to the site. - Each vendor had different format, which was made consistent using the mapping and the Products were ported to the target file. - Included additional logic during the data conversion like Foot to inches, KGs to LBs, dimension calculations, Cost price from List price with any additional charges, based on the vendor image files suit the best for the Big Commerce template image fields. - Based on the Model, MPN or SKU the parent child relationship bought in the logic for bulk uploading. - Attached are the samples of Vendors - OW, Nourison, Dimond the source and the target files. - Have done similar for eBay Turbo Lister, Google Merchant, SalesPresenter
Bachelors in Engineering - Computer Science o Expertise In: (Excel, MS Access, VBA, Data Entry, Webscraping. o eCommerce Data Mapping - eBay, bigCommerce, SalePresenter o Excel - Excel Macros programming, automation, VBA, formulas using data extraction from file and data sources, consolidation, populating graphs, pivot table, lookup,, Excel - Formulas,. Data import/export. o Outlook, Word - Word Template automation, Outlook mails automation. o Data analysis, data extraction from website, populating data on to websites. o MS Access - Designing forms for user input, building reports, Databased designing. Build full fledged software for small institutions on their customized needs. o Database - MS Access, Database Programming, SQL, MYSQL, importing exporting, extraction and modifying data. o Dedicated and would complete to the timelines committed. o Would provide additional support for minor issues/changes to have customer satisfaction and build a long time relationship.