I have an Opencart 2.x website for selling books and I need to create a comprehensive category structure. The good news is that this doesn't have to be done manually as Opencart has an export/import tool and this means I can import all categories in one single operation from a Microsoft Excel spreadsheet.
Therefore I need a freelancer to take the data from these 4 text files and put it into the attached Excel spreadsheet. The data (in the text files) is delimited by commas and will need formatting before being imported into Excel. Additionally, the freelancer will need to fill the other columns within the spreadsheet such as the category id, parent category id, sort order and the SEO keyword for that category.
I have already entered a number of categories manually into this Opencart then exported as an Excel spreadsheet which is attached. Please inspect so you can understand.
To have a better understanding of the category structure, the website has 4 top-level categories:
- Business, Technical and Professional
Each of the above top-level categories have sub-categories so for example, "Business, Technical and Professional" has 7 sub-categories:
- Business and Economics
Then each of the above also has their own sub-categories so there are 3 levels. For example, "Business, Technical and Professional" has the sub-category "Business and Economics" which in turn has the sub-category "Accounting". This gives you the following:
Business, Technical and Professional > Business and Economics > Accounting
- Most of the bottom level categories in the text files start with a category called "General". Instead, I want the category structure purely alphabetical.
Finally before mindlessly bidding for this project, please do actually open up the zip file and look at the contents.
27 freelancer đang chào giá trung bình $24 cho công việc này
Hi, I am interested in your project. Hope you will fully satisfied after completing this project with me. Relevant Skills and Experience Excel Proposed Milestones $20 USD - project
sir I want to work for you,, thanks Relevant Skills and Experience Excel Proposed Milestones $15 USD - Fill in Excel worksheet with data from 4 separate text files
Hi the task is easy I did a C2I training I am a computer engineer student I did similars tasks I agree to do a test work to convince you before hiring me thanks
I will fill Excel worksheet with data from 4 separate text files Relevant Skills and Experience Excel , Data Entry Proposed Milestones $20 USD - Fill Excel worksheet with data from 4 separate text files
i am an engineer good dealing with excel word pdf and others belong to engineering i will do your job in accuracy quality quickly Relevant Skills and Experience excel word pdf Proposed Milestones $15 USD - work
I will do this work in one day or less Relevant Skills and Experience good command of Microsoft Excel to do this work Proposed Milestones $25 USD - i will do this work for 25$ only
good day, I have been working with excel worksheets and micro soft office on a whole for a local construction company for the last 3 years and am very adept in the processes of the entire program.