Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
  1. Hi, Does anyone got to Integration of easy populate with qtpro yet :) that would be nice.
  2. coolguy

    Discount Coupons Exclude Specials

    there is a solution for this in coupons system itself. in admin you have the option to type in the products/categories where coupon can be used.
  3. Hello Scott, thanks for the extrafields addition to easy populate it works like a charm. I have copied your code and tried to add "Attribute Sets" contributions fields to easy populate. So far successful in getting the attribute set id with download but unable to upload the file, easypopulate is throwing errors, I am pasting the code below, i,e modiefied from your version for extra fields, this code may be truly horrible but I sincerely request knowledgable persons to have a look in order to get it to work. STEP 1: Find the following on approx. line 423 CODE // If you have other modules that need to be available, put them here Add the following immediately below this line: CODE // START: Attributes Sets Contribution v2.0a $attributes_sets_query = tep_db_query(" SELECT pas.products_attributes_sets_name as name, pts.products_attributes_sets_value as value FROM ". TABLE_PRODUCTS_ATTRIBUTES_SETS ." pas LEFT JOIN ". TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS ." pts ON pts.products_attributes_sets_id=pas.products_attributes_sets_id WHERE pts.products_id=".$row['v_products_id']." and pts.products_attributes_sets_value<>'' and (pas.languages_id='0' or pas.languages_id='".$languages_id."') ORDER BY products_attributes_sets_id"); while ($attributes_sets = tep_db_fetch_array($attributes_sets_query)) { $row['v_pas_'.$attributes_sets['name']] = $attributes_sets['value']; } // END: Attributes Sets Contribution STEP 2: Find the following on approx. line 1047 CODE // build the categories name section of the array based on the number of categores the user wants to have for($i=1;$i<$max_categories+1;$i++){ $filelayout = array_merge($filelayout, array('v_categories_name_' . $i => $iii++)); } Add the following immediately below: CODE //START: Attributes Sets Contribution v2.0a $attributes_sets_query = tep_db_query(" SELECT pas.products_attributes_sets_name as name FROM ". TABLE_PRODUCTS_ATTRIBUTES_SETS ." pas ORDER BY products_attributes_sets_id"); while ($attributes_sets = tep_db_fetch_array($attributes_sets_query)) { $filelayout = array_merge($filelayout, array('v_pas_'.$attributes_sets['name'] => $iii++)); } // END: Attributes Sets Contribution v2.0a STEP 3: Find the following on approx. line 2072 CODE // VJ product attribs end Add the following code after this line and before the "} else {" CODE // START: Attributes Sets Contribution // Get current list of extra fields $attributes_sets_query = tep_db_query(" SELECT pas.products_attributes_sets_name as name FROM ". TABLE_PRODUCTS_ATTRIBUTES_SETS ." pas ORDER BY products_attributes_sets_id"); while ($attributes_sets = tep_db_fetch_array($attributes_sets_query)) { $v_current_pas_name = $attributes_sets['name']; $v_current_pas_value = $items[$filelayout['v_pas_' . $v_current_pas_name]]; //if row value is not null update, else delete the current entry if value is now null if(isset($filelayout['v_pas_' . $v_current_pas_name])) { // Check to see if this entry has not been added since download //Find key value for this extra field $attributes_sets_id_query = tep_db_query("SELECT pas.products_attributes_sets_id as pasid, pas.products_attributes_sets_name FROM ". TABLE_PRODUCTS_ATTRIBUTES_SETS ." pas WHERE pas.products_attributes_sets_name = '".$v_current_pas_name."'"); $result = tep_db_fetch_array($attributes_sets_id_query); $pas_id = $result['pasid']; //Check if we are inserting, updating or deleting $attributes_sets_exist_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " WHERE products_id = " . $v_products_id. " AND products_attributes_sets_id = ".$pas_id); while ($products_attributes_sets_exist = tep_db_fetch_array($attributes_sets_exist_query)) { $extra_product_value_exist = True; //found an entry } if ($extra_product_value_exist) { // an entry exists if ($v_current_pas_value == '') tep_db_query("DELETE FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " where products_id = " . $v_products_id . " AND products_attributes_sets_id = " . $pas_id); else tep_db_query("UPDATE " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " SET products_attributes_sets_id = '" . tep_db_input($v_current_pas_value) . "' WHERE products_id = " . $v_products_id . " AND products_attributes_sets_id = " . $pas_id); }else { // an entry does not exist if ($v_current_pas_value != '') tep_db_query("INSERT INTO " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " (products_id, products_attributes_sets_id) VALUES ('" . $v_products_id . "', '" . $pas_id . "', '" . tep_db_input($v_current_pas_value) . "')"); } } } // END: Attributes Sets Contribution
  4. Qtpro as it is now doesn't have the feature you want, I am saying this after I saw the image you linked to. I am talking about free version supported by Ralph Day here. There is Qtpro deluxe which has exact feature you are after, please search for it using google or whatever, I am not supposed to post links here.
  5. Thanks for the reply Ralph. I am just trying to add pagination and search to Stats_low_stock_attrib page. I will post the progress here, I have added almost 300 products with attributes tracking stock and Stats_low_stock_attrib page is so long like Great wall of China and taking time to load. On broadband page loads late, on dial up it is getting time out.
  6. Hello Ralph, I have applied the above code to display available stock for attributes like "1 in stock" etc, but Stock is getting displayed with attributes only when pad_single_dropdown and pad_single_radio_set options are set in product information section in configuration, when I use pad_base , in stock thing is not showing, is it the way it is supposed to be or it is a problem? your reply regarding this would save me :) thanks.
  7. I got easy populate populating attributes perfectly. When the setting is off in Easy Populate.php there is no problem, but I need them on. The problem I am facing is Easy populate is ignoring the SORT order of the attributes when we upload, whatever the sort order of a attribute is easypopulate is resetting it to '0'. I am still looking for a way on how to stop this sort order destruction :) I am working with like 350 products on a test site and I am manually updating sort order for attributes every time I upload or change them :( very painful though ;) help is appreciated.
  8. I got qtpro working great now, thanks to Ralph :) As I moved on with my project now I am facing some problem with "Edit orders thing" I have downloaded the contribution below. it is order editor. 1) http://www.oscommerce.com/community/contributions,1435 This tool works nicely but does not update stock when an item is removed from an order. If this Order Editor works with Qtpro life will be lot easier, does anyone of you using Qtpro got this contribution to work with QTpro, if so please enlighten me in what direction I should go to achieve the same. For your information there is a contribution which puts the order back to customers shopping cart and this can be done via admin, then customer adds/removes items from his cart and resubmit the order and order gets updated in admin. It's real cool but I couldn't get this to work too. Link to the the contribution below, Contributions name is Restore Order For Customer Change V1. http://www.oscommerce.com/community/contributions,1161 If Ralph gets this order edit thing going with Qtpro it would be nice. I am aware he is busy but still my request.
  9. Hi Ralph, First a big thank you for taking qtpro to version 4.1. I downloaded it and tried. I just overwritten the "checkout_process.php" , enabled dowload to true. I went on to do a test order, came back to admin and tried to change the status of order, was succesful in doing so. Next I tried to delete an order to see whether the restocking takes place, I checked "Restock product quantity" and hit delete, OSC goes to this url domain/admin/orders.php?page=1&oID=11&action=deleteconfirm and the error below appears 1054 - Unknown column 'opa.products_attributes_id' in 'where clause' SELECT opd.orders_products_filename FROM orders_products_attributes opa, orders_products_download opd WHERE opa.orders_products_id = '57' AND opa.products_attributes_id=opd.products_attributes_id [TEP STOP] I did a test order again and tried to delete the order, this time no restock box checked, just hit delete and order gets deleted successfully and no restocking takes place. I tested 3 times and above error occurs only when restock product quantity is checked. In both cases download is enabled to true. Thanks for your help. :) little testing from my side.
  10. I badly need Credit class/Gift voucher contribution working with qtpro. Qtpro needs download option to be set to false. Credit class/Gift voucher needs download option to be set to true. I am scratching my head to get these two working together but could not succeed, anyone of you using qtpro has succeeded in marrying these two contributions. Help is appreciated. Thanks.
  11. Does anyone succeeded in getting QTpro and easypopulate work together, this is what I am looking for, please post if any of you has achieved this, if you are one like me looking for it I am ready to share the development costs. Thanks.
  12. Hi, Can someone, shed some light here on this Topic plz. Team Members plz have a look here. RAV.
  13. :( anybody...... Respond please.....
  14. Nooobody answering.... :( , O.K may be I am not clear. May be I explain a bit more clearly what I intend to accomplish. Please assume we have 1000 products in a store, which we sell by weight. 1 lb, 2lb, 3 lb etc. Now if we wish to increase the price of a product from the baseprice(take 1 lb, 1 dollar) we have to add the attributes manually with the price increase depending on weight. And when the base price changes we have to update the attributes manually which is very tiresome and labour oriented. I am looking for a solution where we can set attributes so that if we change the base price of 1 lb, price should automatically update according to the option chosen by the customer. This means when customer choses an option to buy 2 lbs, then the set attribute should multiply the base price of 1 lb 2 times so that the price should be updated to 2 dollars. Is this something difficult to achieve with oscommerce. Please there are so many experienced persons in here, please enlighten me in this aspect, because my store development is stopped due to this reason. I cannot go for a custom solution as I am not so rich it is a fact and most importantly I don't want to loose the Rich features and freedom I enjoy using oscommerce. Open source helps people flourish, and me wishing to succeed using oscommerce. Please someone reply to this post, I am ready to talk with someone who are ready to do this for a price (custom work) . I am really in need of help. Thanks, RAV.
  15. Hi there, I have posted about this contribution located at http://www.oscommerce.com/community/contributions,721 , in general support form, may be this inappropriate. I have tried to contact the author to kindly update this Contribution, but Mail bounces back saying his in box is full. All OScommerce team members and experts, Please take time to update this MOD if you have a bit of time. My Store development is stopped because I don't have this contribution. I am requesting you all to take sometime to do this. All this contribution does is add Multiplication option X to the existing + and - options. Please do the needful. RAV.