Jump to content
Latest News: (loading..)

All Activity

This stream auto-updates     

  1. Past hour
  2. Hi, This is something that has forever bugged me and despite all efforts I cannot figure out out to remedy! Can anyone tell me how to make the postcode on the invoice have a line of its own? And ideally how to make the 'county' go to the line above the postcode. I'm in the UK, so I prefer the layout in this order. thank you name street county postcode country
  3. Today
  4. No idea what is wrong. In my shop, customers can buy from all countries and can pay with every payment method. It worked alright from the beginning. If the payment module instantly switches the order status to 'money received' they get the download link automatically on the checkout_success page, if not - like bank transfer - the status is 'pending', and download is disabled. I manually have to set it on 'money received' when I get the money. In the downloads config menu, I have downloads and redirect to true, 7 days, 5 trials.
  5. Sorry, both same issue when customer's country is different than shop country, only credit card available.
  6. ULTIMATE Seo Urls 5 - by FWR Media

    I see the benefit of keep the product name based url constant, but I am not sure the benefit of removing .html. I think it said path rewrite must have .html. So, no!? With Product Listing Ad, CPC company often modify the production title to get higher impression/click thru rate base on seasonal behavior...
  7. @inra311@inra311, I'have just see that, for payment method, only "Credit Card" is available when I have only dematerialized product(s) in my order but If I add normal product, I could choose other(s) payment(s) (if set in admin with zone classes of course). I don't understand why just Credit Card is available and not another payment method ? Is there a configuration to allow different payment modules for download products because I don't see how to set if ?!? Thank you. PS: That's strange, in local I have all the payments shown but in the online shop only Credit Card for download products ?!?
  8. ULTIMATE Seo Urls 5 - by FWR Media

    One thing matters of this addon: if you run a multilingual site you will get URLS like: mysite/index.php/en mysite/index.php/de mysite/index.php/jp and so on, instead of the same mysite/index.php URL for every page/language combination. And you can add hreflang tags so your site will be indexed in the correct local sites - no more duplicate content like in stock oscommerce. If you don't use it or another addon like this one - what language will a search engine index from your site? So yes, it's necesary - or at least very recommended - for companies who sell internationally.
  9. ULTIMATE Seo Urls 5 - by FWR Media

    It could be a good idea to create new URI modules instead of modifying the stock ones. Will give a try if I get some time after updating the addon (i've managed to get the sitemap manufacturer and hreflang pages working completely).
  10. Upon further review I decided that adapting and using the CKEditor for Product Descriptions would be best in my situation... Here is the version I updated and uploaded: CKEditor Text Editor v2.3.4.1 CE: https://apps.oscommerce.com/ngMgE&ckeditor-text-editor-v2-3-4-1-ce Credit To Original Updates: joli811 & ♥mommaroodles Two Versions for: New Install - Drop Files In Place & Modified Install - Edit Code By User CK Editor 4.4.4 full version. If you need the basic or standard version, you will need to download it. Also included in the package is instructions for an alternative method of applying the CK Editor to text area fields. This method imho is better than having to edit the jQuery snippet to exclude the editor on certain text area fields as stated in the package below. Updated to v2.3.4.1 CE From Original Version: https://apps.oscommerce.com/tcmmu
  11. Yesterday
  12. @inra311, Your example seems the regular way. ^^ With mine, in case of cancel (but I had not thought of this eventuality because once the link is available it is often too late to go back), need order_editor to delete the "download" status.
  13. You can enable/disable download access for each status of the order, or did I get you wrong?
  14. @inra311, I saw that to validate the access to the download for the customer it was necessary that the status of the order stay "fixed" on the predefined status that authorize the download... This is too restrictive because if I want to change the status of the command later, access to the download disappears. I modified the query for the download appears and remains accessible on customer side (account_history_info.php) as long as the download status was part of the orders_status_history list. Here is the modification to apply to reach this result. In includes/modules/dowloads.php, find/change like this: // Now get all downloadable products in that order // $downloads_query = tep_db_query("select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd, " . TABLE_ORDERS_STATUS . " os where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != '' and o.orders_status = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '" . (int)$languages_id . "'"); $downloads_query = tep_db_query("select distinct date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd, " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = '" . (int)$last_order . "' and o.orders_id = op.orders_id and o.orders_id = osh.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_filename != '' and osh.orders_status_id = os.orders_status_id and os.downloads_flag = '1' and os.language_id = '" . (int)$languages_id . "'");
  15. Thank you for the feedback @JcMagpie! I just tried Quill.js Product Description WYSIWYG Editor: https://apps.oscommerce.com/Get&PCOBK&2WLz7 and it did not work... easy drop and replace but nothing :-/ I will try these as well and report back!
  16. With this "attibute" for download/virtual item, there is no more shipping address taken into account, only billing address in that case.
  17. My assumption since the first post is that VAT must be displayed for the product even before you know who the customer is. Is everyone else assuming that you don't need to figure the VAT until the customer gives his shipping address? I think we're working on two very different problems. Once you have been given the shipping address, it's easy to figure out the tax rate (merely by country in this case... within US states with multiple tax jurisdictions, it's a nightmare requiring geolocation from the address and determining which county and city the buyer is within). Not having to display VAT to random shoppers would greatly simplify matters.
  18. @inra311 Wahoo, I admit that I discover something there ! Thank you very much !!!
  19. Not sure if I understand your question. Where the virtual products are specified as virtual? Maybe just when they have a download file linked to them under products attributes!? In the Filename field..
  20. @14steve14, @inra311, in includes/classes/order.php, I see that there is a content_type value that could be "virtual" and modify the tax_address : if ($this->content_type == 'virtual') { $tax_address = array('entry_country_id' => $billing_address['entry_country_id'], 'entry_zone_id' => $billing_address['entry_zone_id']); } else { $tax_address = array('entry_country_id' => $shipping_address['entry_country_id'], 'entry_zone_id' => $shipping_address['entry_zone_id']); } Where can we found this "content_type" value ?!? Like for download access, how could we do to make a product a download item ?!? I would like to be able to differentiate "download/virtual" products other than by their tax class. Thank you.
  21. What Is The Best WYSIWYG Text Editor For Admin Side v2.3.4.1 CE? Roll Call - What Are You Personally Using? Is there a contribution that does not change the core code / is a module? I would mainly be using to edit product descriptions... Thank you in advance for your help!
  22. Module Header Tags > Category SEO help please

    Way to go, Ingo! All fixed! Well, looks like I created another problem for myself...no surprise here! I installed the new release on a different server, and then ran the SQL from my 2.2 database backup over it. In the process, it wiped out other entries in the database that came with CE Using the SQL file that came with the new install, I checked the database and manually created anything that was missing. And deleted a ton more...anyone remember Google Checkout? Anyway, must have been going blind at some point as I did not assign 'text' to those entries as I should have. Wonder what other mistake may be lurking now...guess I'll find out! Thanks for all of your help! - Andrea
  23. @MrPhil If the IP address is different because the customer is out of the area and say on holiday, it would not match the location of the delivery address so would not be one of the two required non contradictory pieces needed. This is such a nightmare for the legislation and the paying of VAT I just stopped selling downloads to anyone in the EU apart from the UK. So much easier, but still does not stop those wise people who enter a UK address when buying outside of the UK. Just keeping separate details of every order and from which country the sale came from which is required to fill out the VAT MOSS form every month, if not every quarter, was not worth doing as I sell very few downloads. It was very cost prohibitive.
  24. Bundled Products

    I'm running 2.3.4BS here, and I'm trying to figure out something with how Bundles and the PayPal payment methods interact, in particular the function reduce_bundle_stock which is added into checkout_process.php The reduce_bundle_stock function declaration, as I understand it, would be needed in the PayPal payment methods as well, I would think. Wouldn't it make more sense to add this function into the include/functions/general.php location? Or is there some inheritance I'm not seeing here where the function declaration (and code) is somehow accessible in the other checkout methods and so I don't need to move it into general.php to still be successfully called in the paypal payment? I know there's some interesting ways that the alternate payment methods interact with checkout_process.php but this one has me confused. The concern I have is if I add the new reduce_bundle_stock function into each payment method, wouldn't I then get get a function conflict between checkout_process.php and the two paypal_standard.php and paypal_pro_hs.php payment methods? I tried putting the function into general.php as a a new function called tep_reduce_bundle_stock, and modified the function to call the function by this new name. With this change however, my customer is saying they are no longer receiving the confirmation email, but the orders table is being successfully updated by PayPal when the checkout process completes. I know that general.php is being loaded as there are other tep_* functions in paypal_standard.php which are successfully being called. I can't see why my change of moving the reduce_bundle_stock function from checkout_process.php into general.php would cause the confirmation emails to not go out tho. Checkout via standard methods are working and the bundle stock is being reduced in inventory correctly with the function moved to general.php, but for some reason things aren't working correctly when paypal_standard.php checkout method is being used. I'm a bit at a loss as to why the order process email isn't going out. I've attached the relevant changed files here, in case anyone might be able to see if I'm doing something stupid and just need another set of eyes on it to tell me where things are going off the rails. There is also a function added for LowStockCheck, where if inventory falls below a threshold, then an email goes out to alert that inventory may need to be re-ordered. Unfortunately I'm working with a live system that I'm modifying, so I can't really experiment TOO much here. I've not found a way to (at least without great efforts) replicate the entire store locally for debugging and testing which would FAR rather be my preference, so I have to just make a best effort to making sure I don't knock the store offline or do anything that would confuse customers and/or block checkout. general.php.new paypal_standard.php.new checkout_process.php.new
  25. This is very slow..Has anyone been successful in optimizing these function?
  26. Hmm. "Shopping habits"? Likely a GDPR privacy violation. IP address? What if online by proxy or while traveling out of the country? Billing address? We're talking about guest shoppers, not logged-in members. I don't think this is going to have a happy ending. More EU idiocy. Or at least, one hand doesn't know what the other is doing.
  27. Module Header Tags > Category SEO help please

    Good eyes and suggestion. Dan
  1. Load more activity