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