Find Jobs
Hire Freelancers

Admin features for OSCommerce

$250-750 USD

完了済み
投稿日: 9年以上前

$250-750 USD

完了時にお支払い
We have an existing catalog side feature which automatically draws Specification Tables for individual products and a Specification Summary Table at the top of the category display. We require the admin side to be written so that we can create new types of specification tables and input the column headings (e.g. we have 2 set up already, "tripod" and "monopod", others could be things like "satchel" or "lens"). We also need to be able to associate a Specification Type with a Product and input and edit the table contents for that product. See attached images of the database tables. While we need to be able to edit existing table headings we do not need to be able to delete table types as this adds significant complexity. You can see the catalog side at [login to view URL] - select the "Tripods" or Monopods" categories and any product in those categories to see how the specification tables are displayed. Existing Tables: products_spec_type - Contains one row for each type of table - each row contains a sort order field, the name of the specification table type, the number of data fields in the specification table and 12 fields (f1_name ….f12_name) which contain the headings to be used in the specification table products_spec_nnnnnn - a new table is created for each different specification type ("nnnnnn") - these tables contain a record for each product which has a product spec type of "nnnnnn". Two examples are set up in the database - products_spec_tripod and products_spec_monopod. We require 3 things coded on the Admin side (OSCommerce 2.3.3.4): 1. Create/Edit a Specification table type. In the Admin area the user is given a list of the existing table types to edit, or the option to create a new table. (If editing, the name of the table and the number of fields cannot be changed) When creating a new table the user is prompted for a name for the new table which is validated to contain only characters a..z and 0..9 and no spaces. They are prompted for the number of fields in the table (maximum of 12). Input fields are then generated up to the number specified in the previous step and the user can then input the field headings to be used in the tables into these fields. The first field is pre filled to "Model" and cannot be edited. On Save, the new database table is created in the form products_spec_xxxxxxx where "xxxxxxx" is the name of the new specification table type. 2: When a Category is edited/created have the ability to select a table type from a sorted list of table types generated from the existing database table "products_spec_type". The selected table type is then written to the "categories_spec_table" field in the "category_description" database table. The list should have the default option of "none" in which case the "categories_spec_table" field is set to blank. If the Category already has a table type associated with it then that table type should be the default when the Category is edited. See attached mock-up of how this might look. 3: When editing/creating a product in Admin have the ability to select a table type from a sorted list (default "none") of table types generated from the existing database table "products_spec_type". If the product already has a table type associated with it then this should be selected by default on entering the admin product editing screen. When selected the available fields for the table type are displayed for editing/input - the field headings are also displayed. The first of these fields is pre filled with the products model number and cannot be edited. On saving the selected specification table type is then written to the field "products_spec_type" in database table "products" and the data for the fields is written to the database table "products_spec_xxxxxxx" where "xxxxxxx" is the name of the table type selected.
プロジェクト ID: 6405382

プロジェクトについて

23個の提案
リモートプロジェクト
アクティブ 10年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hi I checked the site and requirement. One query: as in shown image there is 11 fileds So will it fixed or can be more than 11 fields And let me when to start the project Thanks swami
$277 USD 5日以内
4.8 (84 レビュー)
5.5
5.5
23 freelancers are bidding on average $569 USD for this job
ユーザーアバター
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$515 USD 15日以内
4.8 (401 レビュー)
8.2
8.2
ユーザーアバター
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin , Zen cart-Drupal I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$515 USD 15日以内
4.7 (487 レビュー)
8.3
8.3
ユーザーアバター
Hi, I have 12+ yrs. experience of osCommerce/opencart/zencart/wordpress/woocommerce/prestashop/Cre Loaded. I have already worked on hundreds of ecommerce websites including template integration, module installation and custom module development. I have contributed 3 payment modules (eway, netbilling and ccavenue) to oscommerce community and developed many custom payment, shipping, reports and other modules for my clients. Please also visit the following link to see reviews for my experience and customers satisfaction. http://www.freelancer.com/users/feedback_138265.html Thanks for the detailed explanation. I understand the logic to associate a table type to a product, but I do not understand the functionality of associating table type to a category. Where are you using categories association with table type on frontend? you can have tripod associated with category A, but you can select monopod for product 1 under the same category A. Please clarify. Regards Kavita
$578 USD 5日以内
5.0 (318 レビュー)
8.1
8.1
ユーザーアバター
Hello, I have seen your description carefully. I can know what you want now. I am very skilled in this field. I am ready to start work. Wait your message. Thanks.
$526 USD 10日以内
5.0 (8 レビュー)
5.6
5.6
ユーザーアバター
Hello There, Thanks for sharing your requirements with us. We are very much interested in doing the project as we are very much experienced in website design and development. We are expert in every HTML5,CMS/framework like WP, Drupal, Joomal,jQuery / Prototype!, CI, cake php. As well as we are experienced in ROR, Java. I will be grateful if you can share your requirements. Can we discuss the details of this project now?? Kind Regards, Kalyan
$368 USD 10日以内
4.7 (13 レビュー)
4.4
4.4
ユーザーアバター
I have read the details you have given. I have 6+ yrs of experience in PHP and PHP based scripts during my career I have worked on various big and complex projects. I have made unique, complex and different features to Oscommerce, Creloaded projects. I can make the required functionality as per your needs. If you feel fit let me know so we can discuss further about work and can start work immediately. Thanks
$555 USD 10日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

AUSTRALIAのフラグ
FLYNN ACT, Australia
5.0
10
お支払い方法確認済み
メンバー登録日:9月 29, 2008

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。