+1-888-365-2779
Try Now
More in this section

Forums / Ecommerce / 3 Questions, 4 Glitches & 5 Suggestions

3 Questions, 4 Glitches & 5 Suggestions

5 posts, 1 answered
  1. Jochem Bökkers
    Jochem Bökkers avatar
    787 posts
    Registered:
    13 Aug 2007
    04 Sep 2011
    Link to this post
    I'd probably start best with the glitches....

    Glitch: 'On sale' not stored in orders.
    When a product is on sale, it stores only the salesprice in the db. The original price, doesn't get stored in the [sf_ec_order_details] table. The [sf_ec_order_detail] table shows both the on-sale price in the [ttal] and the [price] fields. The [is_on_sale] is flagged with a '1' but nowhere does the discounted amount get stored or the original price.

    Glitch: Child departments can't be moved up or down in the backend overview.

    Glitch: Product search not updated.
    When a product is added, it currently doesn't trigger the product search index to be updated. For SEO purposes it should also update the generic html search index and not just the product index so a catalog page will also be reflecting the latest page output.

    Glitch: Product listing widget error.
    When placing a product list widget on a page when there aren't any (active) products results in the widget giving a 'Object reference not set to an instance of an object'.

    ---

    Scenario: Product catalog / selling can't be limited.
    As a Dutch company I'd only like to sell (non-)shippable products to the Netherlands. Currently there's no mechanism in place to limit sales to a certain country or a few countries. 

    It is possible to setup shipping conditions to apply for only certain countries, but with electronic products shipping limitations don't apply. Will this change in future versions?

    ---

    Scenario: Products shipping & selling from multiple countries.
    As an European company I've got 2 factories, one in the Netherlands and one in Belgium, Dutch orders get shipped and billed from the Netherlands, Belgian orders get billed from the Belgium. I've got 1 ecommerce enabled website in Dutch.

    The only way to allow this to work (and have the right taxes applied) is to create 2 FE languages for the entire website. After having localized all the ecommerce pages and all it's subsequent components I have to translate all my products aswell. Currently localized products isn't implemented yet but I'm guessing its going to be manually add a localized variant, open it and change the applicable tax rate.

    And this solution will only work if the Customer is smart enough to select the proper checkout language version.

    ---

    Scenario: Multiple front end languages & catalogs.
    Imagine we have British company website with 3 FE languages installed (EN-US for America, EN-GB for the UK and EN for Europe). This way our blog/news and pages will be able to serve localized content. 

    If we ship & bill the entire world from 1 location, we'd have to find a way to circumvent all the localization with regards to eCommerce. 
    If we ship & bill the entire world from 2 locations, the US and the UK, we'd have have to create not 2 but 3 product variants, taxes & shipping one for each localized FE.

    If I was stuborn and didn't want to create 2 FE languages & product catalogs, only the Dutch people would have to pay taxes and the Belgium people wouldn't have to even though they are shipped & billed from Belgium.

    ---

    Suggestion: Store location is set in multiple areas.
    In the general store settings we enter the store location, which doesn't do a thing. In taxes we set the location where they apply, but since we're tying taxes to a specific product/language combination, we basically tie them there aswell to a location.

    Wouldn't it be smarter to create some sort of catalog_profile? In there we store the units/culture and shipping/billing location of the catalog and base our catalog on that catalog_profile instead of a FE language version. This would
    also allow for limiting sales (a certain catalog can only be sold in Country of Origin, EU, US or Worldwide).

    ---

    Suggestion: Remove the ability to apply taxes based on shipping.
    Shipping costs should be applied to shipping adress, Payment & Taxes on billing address. The ability to basing taxes on shipping adress is asking for trouble and not just with your accountant...

    ---

    Suggestion: Add the ability to restrict payment methods to countries.
    Store pickup as an example of an offline payment method should be allowed to be limited to a certain country.

    ---

    Suggestion: Apply proper international tax rules
    Currently if a product is sold outside the country of origin, it just dumps all the taxes and considers it an intl sale, resulting in wrong taxes being applied. Tax laws in the EU have some restrictions and rules, and there could be easily incorporated to assure proper billing of intl sales. Can't we follow these steps during checkout:

    1. IF personal order >> Tax applies >> finish.
    2. ELSE IF
    IF local (CountryOfStoreLocation = BillingCountry) >> Tax applies >> finish.
    ELSE IF (CountryOfStoreLocation in EU) AND
                          (BillingCountry in EU AND NOT vat number provided) >> Tax applies >> finish.
       ELSE
         Tax exempt >> finish.

    All sales to (personal) consumers should have taxes applied of the Store country (local, EU, US, WORLD). If it's a business order, within the EU one needs a proper VAT number or else taxes should apply.

    ---

    Suggestion: Untie taxes to a specific country.
    Can't taxes be grouped and then have individual values? And not individual values based on FE language, but freely based on whatever shipping/selling country is specified. Imagine have store outlets in every EU country, but the website only in English. 

    This would require several applicable taxrates (NL:19%,BE:21%,DE:19%,UK:15%) to the same product. If taxes are localized based on FE languages, I'd have to create localized values for each tax and each product to assign it the proper tax.

    So someone who only sells from the Netherlands defines the tax 'Highrate' just to Netherlands 19% but someone billing from Netherlands and BE can set 'Highrate' to 19% for NL, 21% for BE and 19.6% for FR.

    He could even accomplish this with 2 FE languages Dutch & French and leave it up to people in Belgium which language version they'd like to view.

  2. Stevo
    Stevo avatar
    20 posts
    Registered:
    09 Sep 2007
    07 Sep 2011
    Link to this post
    Thank you Jochem for the suggestions and glitches. We greatly appreciate your time and feedback.
    As you know there are many conditions to meet for U.S and Euro taxes (VAT). Eventually we will be integrating with 3rd party tax SAS applications, and many require different scenarios, EX: tax based on shipping address, etc.. We will be providing additional tax/vat features in future releases, and the suggestions you have given us have been added to our feature list.
    Thank you again and keep suggestions and glitches coming !!
    Steve
  3. Venkata Koppaka
    Venkata Koppaka avatar
    67 posts
    Registered:
    24 Sep 2012
    08 Sep 2011
    Link to this post
    Hi Jochem,

    Thank you for all your suggestions.

    Glitch: 'On sale' not stored in orders.
    This issue has already been fixed for the upcoming SP release.

    Glitch: Child departments can't be moved up or down in the backend overview.
    This is an issue with taxonomies in general(departments is also a taxonomy). I have logged this issue in PITS.

    Glitch: Product search not updated.

    I have forwarded your request to the team, you can follow its status here.

    Glitch: Product listing widget error.

    Can you give me more detail on how to reproduce this error? I was not able to reproduce this error.

    Scenario: Product catalog / selling can't be limited.
    I have forwarded your request to the team, you can follow its status here.

    Scenario: Products shipping & selling from multiple countries.
    Scenario: Multiple front end languages & catalogs.

    We are planning to add multiple language support for catalogs in Sitefinity 4.3 and tax implementation is changing in SP release which will address some of your concerns.
    I have also forwarded your other issues to the team.

    Suggestion: Store location is set in multiple areas.

    This is a very nice suggestion, I have forwarded your suggestion to the team and you can follow its status here.

    Suggestion: Remove the ability to apply taxes based on shipping.
    Well, we have some customers who requested this feature, which is why the feature made it to the release. An ideal example would be customers from Texas who ship their products to Texas in general will
    have to pay tax on their shipping compared to other places.
    Is it possible for you to not use the feature?

    Suggestion: Add the ability to restrict payment methods to countries.
    I have logged your suggestion. You can follow the status here.

    Suggestion: Apply proper international tax rules
    As I mentioned above, tax implementation is more robust in SP release, but I have forwarded your suggestion to the team for review with the latest implementation.

    Suggestion: Untie taxes to a specific country.
    I have forwarded your suggestion to the team, you can follow the status here.

    I have also updated your Telerik points as a thank you for all your suggestions.

    Kind regards,
    Venkata Koppaka
    the Telerik team

    Answered
  4. Jochem Bökkers
    Jochem Bökkers avatar
    787 posts
    Registered:
    13 Aug 2007
    08 Sep 2011
    Link to this post
    Hey Steve & Venkata,

    Thanks for taking the time to adress all this...

    From my limited view, the easiest and most flexible way to address these and other weird scenario's is to introduce some sort of catalog profile which is independent of a FE language. Inside you define all the parameters for which the catalog is active (metrics/taxes/shipping/sales/PointOfOrigin/cultures/etc). And then you link up a catalog profile to a frontend (localized) view.

    But can't way to see the next SP to see what's changed!

    @Venkata,
    To reproduce to product listing widget, remove all the products. Create a page. Drop the product list widget onto it, click on edit and go to the second tab. Then you'll get the 'Object not set...' message. 
  5. Stanislav Velikov
    Stanislav Velikov avatar
    1113 posts
    Registered:
    05 Dec 2016
    12 Sep 2011
    Link to this post
    Hi Jochem,

    I can`t reproduce the bug when going to the second tab in product list widget. Can you try this scenario at a test project and see if you will reproduce it there?
    Maybe you have done some additional changes to e-commerce module to trigger this? If you did please share share them with me?

     The error you describe should be concerned with the edit dialog that opens when you edit the widget and the template for one of the views is not accessible or virtual path to it is deleted. You can check if you have all default virtual paths in Administration->Settings->Advanced->Virtual Paths Settings.

    Regards,
    Stanislav Velikov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
5 posts, 1 answered