Jump to content
Latest News: (loading..)

cdetdi

Members
  • Content count

    17
  • Joined

  • Last visited

Profile Information

  • Real Name
    Corey

Recent Profile Visitors

1,681 profile views
  1. cdetdi

    Paypal Express Dropping Tax Calculation

    Fixed for now - I added a function in general that looks to see if the PAYMENTREQUEST_0_TAXAMT is in the Paypal array which then turns on the tax rate I need. The fact that this works suggests that it was the shop that calculated the rate by itself (disregarding the PayPal return) and the shop was dropping the tax rate.
  2. Struggling with PayPal Express checkout dropping the sales tax amount when entering the confirmation page. Background: Not a standard tax installation. We offer customers the ability to prepay duties/taxes/fees for international shipments. For certain shipping methods we require those to be paid, on others they are not required. We've gotten pretty far getting PayPal to play nicely with our hacked setup, but, we're struggling in one instance of express checkout. Tax Amount Shows Properly on PayPal Screens. When switching shipping method tax calculation behaves as intended. When we get back to the order confirmation stage on our shop there is no tax on the order confirmation. Looking at the session information, however, [TAXAMT] and [PAYMENTREQUEST_0_TAXAMT] are being passed correctly. I'm assuming that the order total module check on my site is kicking out tax because of some condition that got unset when going to PayPal and coming back. Questions: Does the OSC PayPal app pay attention to the tax variables passed back from PayPal - or - does the site do its own tax/order total calculations? If it DOES use the passed variables - where are those processed back to the shop so they appear in the order confirmation? I've done a few hours of grep trying to follow stuff around the PayPal app, but I'm not getting very far. Any help is appreciated - I know that my installation and request are bespoke, any insight into how this data is handled can help me get to the answer.
  3. I'm very surprised this topic hasn't been opened yet, perhaps it is going on in another forum that I have not seen yet. On June 21, 2018, the US Supreme Court reversed over a decade of established precedent that allowed sellers to not collect sales tax on out of state transactions. For an online only company like ours, this is a small nightmare. We are now required to collect sales tax and remit it individually to each state if our sales total over 100 or revenue over $100,000 within a calendar year. This means 46 different tax rates and monthly filings. Since this change in law came from the court, rather than from new legislation, each state has put out (or is trying to put out) new legislation and guidance for how out of state sellers should deal with that state's respective sales tax. To make things worse many areas have "local" or "county" based tax rates on top of what their state charges. There are thousands and thousands of different tax rates throughout the country. Our sales exceed that threshold in all states except 1 or two, so we are now left struggling with how to deal with this new tax situation. My initial response was to simply create the 46 tax zones necessary and remit tax to those 46 states every month. However, this ignores all local/county tax regulations, too. I have found a collection of third-party service providers who make sales tax rating tools. These are pay services (of course, another expense just so that we can pay more money) and would require work to allow their APIs to plug into the oscommerce framework. I don't know of any add-on or module that can integrate my shop with a third-party tax rate. I would like to hear from other shop owners who are also struggling to determine the best course of action to comply and perhaps together we can formulate a good way forward.
  4. Struggling with Paypal and this add on. I had this working with earlier Paypal versions but since a recent Paypal update I must have lost a change along the way... The discount itself works when paying with paypal, but I cannot get the customers_to_discount_codes to update. If I have the code in the paypal_standard file to do this I get an SQL error that there is no value for discount code, so the discount code id is being dropped somwhere along the way. 1366 - Incorrect integer value: '' for column 'discount_codes_id' at row 1 insert into customers_to_discount_codes (customers_id, discount_codes_id) values ('116812', '') I quickly parsed through the thread to see if I could find anyone else with this issue but didn't come up with much. C
  5. Right - there would need to be some gatekeepers for this.
  6. Coming from the client-end having "certified" devs would be extremely useful. You spend enough time combing through the code in modules and you learn who codes well and who doesn't, but that takes a LOT of trial and error and at least a workable knowledge of LAMP stack. Certified Developers would be clearly noted in the add-ons page. Certified Developers would have more details about project contracting, availability, specialties.
  7. cdetdi

    KissIT Image Thumnailer

    Suggestion for future: PHP is horribly inefficient in creating thumbs, so there is a max filesize that can be handled. While no one should be uploading 2MB photos, the code still should protect against this secenario. Right now, if creating a thumbnail maxes out the memory limit it just crashes the page. Suggestion - limit filesize in tep_image, if too large escape to temp image. if(!file_exists($src)){ $src = '/images/pending.gif'; } elseif (filesize($src) > 2000000){ $src = '/images/pending.gif'; }
  8. Great module, I had put this into my old site by hand, extremely useful. Thanks raiwa.
  9. Honest review - This is a pretty terrible module. Installation instructions are backwards, they don't specify clearly what to edit and where, edited files are not commented nor are they correct. I strongly suggest others to try another method. This module is NOT bootstrap compatible. For one, this module relies on a new field in the products database called "products_images" but, the included product_info.php does not use this field. The "patch" for this has been copied and pasted into this thread, but is not part of the package, and the copy-pasting is not accurate either. Moreover, the point of the bootstrap system was so that users could easily plug in new modules and remove them as needed. This module was not re-written for this - you cannot add/remove this via the configuration pages.
  10. cdetdi

    Purchase Without an Account?

    I do. I deployed the Order Without Account module that deleted customer information but it was NOT a good experience. Deleting customer data post-order made customers near impossible to find when they called. It also required the customer to complete check out, which means we had a bunch of phantom accounts in the database that unexpectedly deleted themselves when we helped the customer place the order. Overall, it was a pretty poor experience. If I were to imagine an order without account system working I think whitehat's idea is the way to go. Customer enters name, address, e-mail and checks out. An account is created with a random password. Customer receives an e-mail that thanks them for using guest checkout, then provides customer with login details anyway, something along the lines of "if you want to track the status of your order go here and enter your e-mail address and this code." So, what about repeat "guests". That is more challenging, I think. On the one hand, you could just simply allow account creation with the same e-mail address. Each time the customer checks out it creates a new account for them. Alternatively, you *could* just insert the new order and attach the existing customer ID, though, that gets messy.
  11. cdetdi

    ULTIMATE Seo Urls 5 - by FWR Media

    I have SEO URLs working properly for standard configuration, however, when I try to enable Header Tags as SEO name I get an error on the first page load. Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /home/idp2/idp2.didyoube.com/includes/classes/seo.class.php on line 152 Then, all my products lose the SEO friendliness, instead just using the product id, e.g. "-p-28.html" I have header tags installed, so I wondered what was going on. Admittedly, I am not very familiar with how this module functions, but, a cursory glance turned up something (which may be nothing) In function generate_products_cache line 2015 is this: $sqlCmd = $this->attributes['USE_SEO_HEADER_TAGS'] == 'true' ? 'IF(pd.products_head_title_tag_url !="",pd.products_head_title_tag_url,pd.products_name) as name' : 'pd.products_name as name'; In my version of header tags, there is no products_head_title_tag_url in products_description. Rather, there is a products_seo_title. I changed all the products_head_tag_url references to products_seo_title and things seem to be working. Have I hack-created a frankenstein here by forcing two modules that weren't supposed to go together? Am I working with the wrong version of the header tags module?
  12. cdetdi

    [Addon} Superfish Categories Box

    Thanks Jim. Any interest in turning this into a drop-down menu that could go into the header? (See Amazon, NewEgg etc.)
×