Jump to content

brian175

Members
  • Content count

    8
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Brian
  1. brian175

    QBI Quickbooks Import

    Thanks Adam!! Not only a well written contribution, but excellent documentation and support. I have just installed on my test store and have been "practicing" will a test QB company. So far so good, everything seems to be working, but I did noticed that in the Taxes section, the docs mention a "Description" field that must match exactly... This field is missing from the Configure page. I haven't tested a sale with sales tax yet so I don't know if it will be an issue.
  2. Aleem, Thanks for the reply! Is there a recommendation on what is the best "full" package to start at? The 5.14 claims to include all 5.13 fixes but I have run into these problems: 1) Duplicate function calls in add_ccgvdc_application_top.php and general.php (in both the admin and catagory section. I found a post much earlier that states to remove from general.php since the functions are specific to CCGV which makes sense 2) French in the Admin section (your link should take care of that) 3) Duplicate Vouchers/Coupons listing in the Admin list (saw issue, haven't tried to find answer) 4) In the shopping cart, when I click to "Redeem" a coupon I get what appears to be an incomplete statement "Congratulations, you have redeemed". 5) From this point on the coupon is listed in my cart but has no effect on purchase So, based on all of the issues I was thinking it would be best to start from an earlier full package and apply the fixes since they don't appear to be in the 5.14 anyway. Back to my original question then, how far back should I go and is there a list of fixes that I should apply. (If not, I will record and post back) Thanks, Brian
  3. I am also getting this error: I commented out the duplication in add_ccgvdc_application_top.php but I'm not sure if this is correct. I can get past the redeclare error but coupons are not reducing the cart total. I started with the 5.14 complete install, is there a known issue with the package or is it something else. I do have other contributions added to my site. Thanks, Brian
  4. brian175

    Bundled products

    found another conflict with QPBPP (line #421--In /catalog/admin/categories.php) $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_bundle from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); I also have solved the download problem that I posted earlier. For example lets say you have the following: Bundle 01 >Product A >Product B >Product C and Products A, B and C have downloads If someone purchases Bundle 01, the downloads for the subproducts are automatically added to the order and they are named after the subproducts NOT the bundle. I have also added code that shows the subproducts as attributes of the bundle so in the cart and invoice looks like: Bundle 02 - Subproduct: 1 x Product A - Subproduct: 2 x Product B - Subproduct: 1 x Product C I need to test some more, but can post if there is interest
  5. brian175

    Official PayPal IPN Support Thread

    Hello, I was having a very similar problem to others in this thread: the total amount returned from paypal was different by $.01, which was preventing the order status to be updated. In my case, it was the sales tax that was off by $.01 The solution turned out to be switching the transaction type from "per item" to "aggregate" and this is why: Qty = 4 Price = 29.00 tax rate = 8.25% sub total = 116.00 tax = 9.57 total = 125.57 But with "per item" paypal was showing tax = 9.56 total = 125.56 and the reason I believe is that osc calculates the tax individually when "per item" is the transaction type. Therefore, 8.25% of 29.00 = 2.3925 which gets rounded down to 2.39 and 4 x 2.39 = 9.56!!! (I also tried changing the tax decimal places from 2 to 4 but that did not fix the problem) I also just did a quick check and tried to change the US number of decimal places from 2 to 4 just to see if the extra tax info would be passed, but I got a malformed url error from paypal.
  6. brian175

    Bundled products

    I've looked into this and I think I may have a solution. The list of downloads available for an order is stored in the table orders_products_download which gets updated in checkout_process.php. Currently it just uses the order_products to find downloads and update the table. However, if a check could be performed to see if the order_products is a bundle, then the subproduct_id(s) from the products_bundles table could be used to update the orders_products_download for the order. My first question is am I on the right track and the next question is can someone help my with implementing? Thanks, Brian
  7. brian175

    Bundled products

    Just installed v1.4 and everything seems to be working. My store is not "live" yet but I have made a few test orders. For those interested I also have 1) Downloads Controller 2) PayPal IPN (osCommerce version) and 3)Quantity Price Breaks per Product installed. There was only one conflicting line with QPBPP (line #72 --In /catalog/admin/categories.php but it was easy to combine into $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); I do have one question, it is somewhat of a repeat of an unanswered question earlier in this topic. The bundles that I am creating are software downloads, so when a bundle is purchased I need to provide the download. I can accomplish this by creating product attributes and assigning multiple attributes to the "bundled" product. Is there way to allow existing attributes of the sub products of a bundle to be included with the bundle? If not, any ideas on where to start? Thanks to everyone that has added to or helped with this contribution. Brian
×