Ecommerce invoicing and tax caluclations for multinational stores where all prices are stored as rrp with tax included

forums_noreply@adobe.com — Thu, 06 Nov 2014 17:42:22 GMT

We have a client that has a large ecommerce store with around 900 products.

The below scenario is stumping us and have found only one real work around but it requires using 3rd party apps to do the invoicing.

Any suggestions from Partners or devs that have a similar issue would be greatly approciated.

Taxation – Current prices include tax, need pricing schedule for countries

Currency 1 is $AUD and GST tax rate. Prices to be entered as inc tax. Tax deduction to calculate back from RRP
Currency 2 is £GBP and VAT rate. Prices to be entered as inc tax. Tax deduction to calculate back from RRP
Sub domains needed for each currency
Deduct the tax for none tax countries
Calculating or reporting on tax amounts for BAS

Comments

Potential is TWO currencies. Each to have RRP entered manually.
Which currency displays will depend on where customer access to website is from. AU will show for all world initially, later to be broken down as AU (for AU, NZ, Oceania, Asia,) £GBP, for rest of the world Deductions automatic for all consumer retail purchases when customer is outside

Testing
- using discount code hidden in shopping cart to detect country from drop down and then removing tax from rrp (or using JS to detect url and adding code automatically, this has been tested and is working)
- invoicing for different countries to be different
- using the api to remove the tax for non tax countries
- using api to retrieve tax summary

So far the solution we are suggesting but there might be issues with syncing with a server hosted Myob Accounting package

Specifications for SET up

Accounting package - MYOB is Account right plus. Just downloading V2014.16.7861
BC shop has about 900 products
Options for syncing data
- http://myob.com.au/addons/listing/41/transpost/
- http://www.onesaas.com/integrate/myobaccountright-with-businesscatalyst (looklike this might not work with server hosted)

Systems restrictions that we can’t get around

Invoicing - for some reason there is only one system invoice, if this was not the case we could easily set up different invoice formatting and content for each region and apply appropriate tax calculation.

Proposed set up based on findings

based on extensive consultation with Business Catalyst, reference material and testing the following configuration and management is the best solution and in some cases the only available solution to satisfy the criteria set out above.

Sub domains for regions

3 regions should be set up UK, AUS and Rest of the world. UK and Rest of the world should use subdomains while Australia would use the default domain. UK.dccconcepts.com, world.dccconcepts.com and dccconcepts.com

Displaying different currencies

Subdomains and using country drop down in the shop to direct people to the correct currency symbol and pricing.

Deducting tax from rest of the world.

As the discount system is not in use we are able to create a script that will deduct the required amount when shoppers are in this region by checking the url they are on and applying the discount. Their order total would then reflect price with the deducted amount.

Invoicing

As every order is checked manually we are proposing that the system invoice is modified to show the order total and explain that a sales invoice will be sent out once the order is finalised with tax, shipping and order modifications if required.

The order informatiuon would be sent to the accounting package via onesaas.com sync up

http://www.onesaas.com/integrate/myobaccountright-with-businesscatalyst, this needs to be further investigated to make sure it works as advertised. Or http://myob.com.au/addons/listing/41/transpost/ ( this would be a more manual process but looks like the better option for syncing with a server based myob)

You can then apply your tax, shipping and amendments and add tax exempt labels just like you do now with server hosted package to the level of detail you wish.

Reporting BAS would then be as per your normal account process.

What I find very frustration is that eCommerce is supposed to be multi currency , muti national but simple things like have a different invoice for each region created like they have with a separate shopping cart for each region and VAT, BAS and tax reporting a fundimental activity for business in all countries is lacking

Again any incites or solutions would be greatly appreciated.

mass delete crm contacts

forums_noreply@adobe.com — Mon, 30 Jun 2014 11:39:26 GMT

has any one found a clever way to mass delete crm users in BC

like sync with a empty database

what I really want to do is import a list of entities to delete and have the system do that.............

Employment company app

forums_noreply@adobe.com — Sun, 10 Mar 2013 12:11:02 GMT

We are trying to create an app using the built in features of BC

Bascialy we can use the CRM to capture Employee candiddates, Employer clients, Companies and we can create job listings using web apps.

The problem is creating relationships.

We have played with using products for the job order and have the client and the employer purchase the product to creaste the relationship.
Tried using web apps but the relationship using datasources will get hard to manage considering they have 8000 candidates in the system.
Tired adding custom fields to the crm fields and use relationships to mangage the interaction.
Thiniking about using events or useing the crm for employers and candidates and web apps for the actual job.

Any sugestions would be great.

Blog urls - BC allows any text to be appended to the end of blog urls

forums_noreply@adobe.com — Fri, 08 Mar 2013 08:18:47 GMT

I just ran a test crawl on our main site and the bot found 87 duplicate urls

All the blog posts showed the post and then one identical post with /privacy-policy appended ot the end.

The content is idendtical

I am attempting to descover why only privacy policy is appended.

My major concern is that any content can be appeneded to a blog post and show ducpolicate content.

A malicious attacker could create a small script that takes all the post appends them with an infinante array of variables and post those links on websites, get the links indexed and then google would flag a site as having disprortionate amount of duplicate content.

Any ssuggestions?

Adobe Community : All Content - All Communities