Fix an Excel sheet and improve

50.0 GBP

50.0 GBP peopleperhour Technology & Programming Overseas
163 days ago

Description

Hello
I would like to fix an excel sheet and improve it, where possible. Plus add more rows for data to be entered. And April 25 to March 26 to be added. Plus a VARIOUS branch to be added.
I need this doing by the end of Wednesday 22nd Jan. I will send you the spreadsheet once accepted the job.
Thanks
Darren

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Opencart Version 3.0.3.6 data migration to Latest Version of NopCommerce Please see our Opencart website and a staging website I have created for this migration.. 1 - How long will the migration take and what access would you require.. 2 - How will you make the transfer, what are the steps involved to include the full history of.. Number Of Products - 4580 Number Of Orders - 25233 Number Of Customers - 7353 Number Of Blog Posts - 17 3 - It must contain the SEO data such as the SEO URL, Meta Title, Meta Keywords, and Meta Description & abcProducts . ID , Name , SKU , Short Description , Full Description , Images in Description , Status . Price . Meta Title , Meta Keywords , Meta Description. . Product Image , Additional Images . Quantity , Stock Availability , Manage Stock , Stock Status . Weight , Width , Height , Depth . Related Products , Product Tags . Product Attributes (Name, Values) abcProduct Categories . Name , ID , Description , Status . . URL , Meta Title , Meta Description , Meta Keywords . . Category Images . abcCustomers . ID , First Name , Last Name , Email , Telephone , Customer Group , Newsletter , Passwords , Created Date , Status . . Customer Billing Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone, Fax). . Customer Shipping Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone, Fax). abcOrders . ID , Order Date , Order Status , Custom Order Status , Order Products (Name, SKU, Option, Image) , Product Price , Quantity , SubTotal Price , Discount Price , Tax Price , Shipping Price , Total Price , Order Comments , Order Status History . . Customer Name , Email , Telephone , Billing Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone). . Shipping Address (First Name, Last Name, Company, Address 1, Address 2, Country, State, City, Zip Code, Telephone). --------------------------------------------------------------------------- A - I’ve created a fresh NopCommerce installation specifically for this job. We’ll be transferring all the data to the following staging URL: https://eloquent-merkle.217-154-22-152.plesk.page B - Current Opencart website - TBC once project agreed ------------- Here’s how you may handle it: Export all data (products, orders, customers, blogs) from Opencart, clean and structure it properly. Import it into NopCommerce using its built-in tools or custom SQL scripts where needed. Test everything thoroughly to make sure the data is accurate and displaying correctly. The process is very similar too: exporting data via phpMyAdmin, cleaning/mapping in CSV or Excel, and importing using your own platform tools or your own SQL scripts. You will of course review NopCommerce’s import structure. ------------------------
150.0 GBP Technology & Programming peopleperhour Overseas
1 days ago