Find Jobs
Hire Freelancers

Create product data feed from Access Database

$100-500 USD

Completed
Posted over 18 years ago

$100-500 USD

Paid on delivery
Create [login to view URL] feed from productcart Access database. Approximately 2000 sku’s. Use Query to create excel spreadsheet See attached spreadsheet for example of template for [login to view URL] First transfer access to excel spreadsheet Review for completeness and accuracy Then Export into comma delimited txt file. Issues ??" figuring out a way to pull out and assign key words to products Perhaps a list of 4 to 20 keywords per category/sub category and assign randomly, or by other criteria. You will be expected to research and develop all necessary keyword lists. More detailed discussion of keyword development There have been several questions about Keyword development, there are about 100 categories. I have grouped them into 35 category's for keyword development. About 10 keyword phases per category group should be more than enough. The keyword for each product would be parent category, category, product name, keyword phase, keyword phase. Plugging in the category name into wordtracker or similar software should provide the list of 10 or so keyword phases in limited amount of time. Those keywords in a table, with a category id, and selected and inserted in to the product record based on the product category should rotating though the list, when there are more products than keywords would be fine. Short description and description from database should be combined into feed description field, html is allowed. Custom field code data goes into manufacturers product code field Image one should be the detailed image , image text should be the item name Image two should be the general image [login to view URL] to see product listings ## Deliverables An Acces database query what will create / fill a access table in a seperate access database from the productcart database sturcture to meet [login to view URL] template requirements. ( Special requirement - each product will have between 2 and 5 appropriate related keywords.) Clarification: The end result should also include a access query that can be used to update, the feed as products are added to the product database. Alternatively a visual basic program could be used if a visual basic program is used it must include source code and be very heavily comments to allow entry level programmers to modify, like add a new product category level or option. An Excell spreadsheet from an export of the access table that meets the requirements of the [login to view URL] template. A completed txt file feed for [login to view URL] 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Tuesday Nov 1, 2005 2:18:53 PM: There have been several questions about Keyword development, there are about 100 categories. I have grouped them into 35 category's for keyword development. About 10 keyword phases per category group should be more than enough. The keyword for each product would be parent category, category, product name, keyword phase, keyword phase. Plugging in the category name into wordtracker or similar software should provide the list of 10 or so keyword phases in limited amount of time. Those keywords in a table, with a category id, and selected and inserted in to the product record based on the product category should rotating though the list, when there are more products than keywords would be fine. ONE Other Issue: The end result should also include a access query that can be used to update, the feed as products are added to the product database. Alternatively a visual basic program could be used if a visual basic program is used it must include source code and be very heavily comments to allow entry level programmers to modify, like add a new product category level or option. ## Platform Access 2000 excell 2000 XP
Project ID: 3056001

About the project

13 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$102 USD in 30 days
4.6 (87 reviews)
6.3
6.3
13 freelancers are bidding on average $268 USD for this job
User Avatar
See private message.
$348.50 USD in 30 days
5.0 (129 reviews)
7.8
7.8
User Avatar
See private message.
$424.15 USD in 30 days
5.0 (167 reviews)
7.5
7.5
User Avatar
See private message.
$152.15 USD in 30 days
4.9 (409 reviews)
7.1
7.1
User Avatar
See private message.
$165.75 USD in 30 days
5.0 (70 reviews)
5.2
5.2
User Avatar
See private message.
$85 USD in 30 days
5.0 (45 reviews)
5.0
5.0
User Avatar
See private message.
$425 USD in 30 days
5.0 (2 reviews)
1.9
1.9
User Avatar
See private message.
$637.50 USD in 30 days
5.0 (2 reviews)
0.5
0.5
User Avatar
See private message.
$106.25 USD in 30 days
0.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$467.50 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$340 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$127.50 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$102 USD in 30 days
0.0 (3 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
4.9
36
Member since Feb 21, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.