Re: [development] Creative ideas?
In the spirit of keeping my response on the list... Jeff, you can contact me privately if you want a link to the site in question. It was done under another company I worked with, so I don't want to take open credit for it :) -- Ian Bezanson Bezanson IT Solutions irb@bits.co +1.902.442.8392 On 2010-10-20, at 9:56 AM, Ian Bezanson wrote:
I'm trying to remember, exactly :) The one we'd done was actually the latter case you describe. It was for a Jewelry company, based out of Halifax, NS, Canada with an online presence in Canada, US, Australia and a few other countries. We built the system, off of a single install so that each product could display in a single country, or all countries. I believe that the SKU was shared as well. I don't think we'd used the Ubercart Domain Access module, but it sounds like just the ticket, as it will label a purchase of any SKU with the appropriate domain it was purchased under. So.. I'm guessing the only custom-ish thing you may need to do is build an admin view to show reports per country, if that isn't a part of said module.
So, long and short - if Widget was set as SKU 001 and was configured to be shown in US, Canada but NOT Mexico (let's say), it will appear on the Canadian and US domains, but would not show up as part of the Mexican storefront. If you purchased from either US/Can, it will come through with the single SKU, marked somewhere in the system with that country.
Not sure if that clarifies or helps :/
-- Ian Bezanson Bezanson IT Solutions irb@bits.co +1.902.442.8392
On 2010-10-20, at 9:41 AM, jeff@ayendesigns.com wrote:
Ian,
I'm thinking that what you did results in being able to sell Widget in several languages and currencies, all sales coming from one inventory. And that uc_domain would modify the invoices, etc. based on what country the items were ordered from. Is that correct?
In this case, Widget would be item 001 in the U.S., item 002 in Canada, etc. so that an order for it from the U.S. would not come from the same inventory as an order for it from Canada, and all the downhill books (sales accounting, distribution) would follow.
In other words, what you did would seem to be for one company and source of goods sold to many places, where what I would need is the company headquarters (with the admin panel) having a distribution company in each country, each with their own inventory and accounting.
Jeff
On 10/20/2010 05:31 AM, Ian Bezanson wrote:
Jeff:
You'd be better off, and likely have less headache to utilize the Domain Access module (http://drupal.org/project/domain) to achieve the latter bit, rather than separate installs, sharing a database. I've built a multinational, multilingual storefront with Drupal and Ubercart earlier this year and that was definitely the way to go - you can manage content per domain, or make it available for all domains, use different themes per domain, etc. If nothing else, come upgrade time you will thank yourself for doing it this way as you'll only have one site to maintain and upgrade - plus then your admin section IS in one spot, rather than having to fake it together.
As for general store/reporting separation, take a look at Ubercart Domain Access (http://drupal.org/project/uc_domain) which claims to allow "...an Ubercart store to span multiple domains, storing the originating domain when an order is made and displaying the correct store information on invoices."
I'm sure you'll have to do a little bit of exploration to make it all work together happily, but venture to guess it will be less time than the other approach.
Hope this helps,
-- Ian Bezanson Bezanson IT Solutions irb@bits.co +1.902.442.8392
On 2010-10-20, at 2:38 AM, jeff@ayendesigns.com wrote:
Btw, what I'm considering is separate sites, a shared db with different prefixes, one login to access any panel from that point on, and al sites having menu links between admin panels, so it appears as one panel. Ayen Designs - quality software the first time, every time!
-----Original Message----- From: jeff@ayendesigns.com Sender: development-bounces@drupal.org Date: Wed, 20 Oct 2010 01:18:40 To: <development@drupal.org> Reply-To: development@drupal.org Subject: [development] Creative ideas?
I have a client, who has a client, with a D6 site and Ubercart store.
They now want to take their store international (since their business has become so), and want to be able to have separate store financials (fulfilment, checkout, reports, inventory, etc.) for each country, as well as separate site functionality for things like blocks, etc. ---- all from one admin panel.
I know there's a module to specify content availability by domain. There is also a module to allow one store to stretch over several domains, but it doesn't segregate the 'inners' of each store.
I thought I'd ask whether anyone knows if this has been done. Second reactions, I guess, since the first are likely to be either 'hahaha' or 'sure...a team and several months' :-)
Well, so far that sounds doable, that the only development would be simulating separate books based on the sku. If I can 'fudge' separate catalogs by controlling which store the item appears on, and separating each store's items out for reporting later, that could work. The one stumbling block would seem to be payment, which I don't think can be overridden by product, and possibly shipping, which I think cannot either other than as flat-rate groupings. The payment part interests me on two levels, because I'd started the module uc_gateway_mediation and one of the requests is that it mediate based on currency, that is, choose the online merchant to use based on the currency in effect for that location. I'll contact you for a link if you think it will show me something, given that I'd only be looking at it from one country, and would not be seeing the admin side at all. Jeff On 10/20/2010 09:02 AM, Ian Bezanson wrote:
In the spirit of keeping my response on the list...
Jeff, you can contact me privately if you want a link to the site in question. It was done under another company I worked with, so I don't want to take open credit for it :)
-- Ian Bezanson Bezanson IT Solutions irb@bits.co <mailto:irb@bits.co> +1.902.442.8392
On 2010-10-20, at 9:56 AM, Ian Bezanson wrote:
I'm trying to remember, exactly :) The one we'd done was actually the latter case you describe. It was for a Jewelry company, based out of Halifax, NS, Canada with an online presence in Canada, US, Australia and a few other countries. We built the system, off of a single install so that each product could display in a single country, or all countries. I believe that the SKU was shared as well. I don't think we'd used the Ubercart Domain Access module, but it sounds like just the ticket, as it will label a purchase of any SKU with the appropriate domain it was purchased under. So.. I'm guessing the only custom-ish thing you may need to do is build an admin view to show reports per country, if that isn't a part of said module.
So, long and short - if Widget was set as SKU 001 and was configured to be shown in US, Canada but NOT Mexico (let's say), it will appear on the Canadian and US domains, but would not show up as part of the Mexican storefront. If you purchased from either US/Can, it will come through with the single SKU, marked somewhere in the system with that country.
Not sure if that clarifies or helps :/
-- Ian Bezanson Bezanson IT Solutions irb@bits.co <mailto:irb@bits.co> +1.902.442.8392
Oh sorry... let me rephrase a bit. No need, whatsoever to fudge the catalogs by domain, that's actually part of the domain access modules. You have the ability to "show on all domains" or pick specific domains to show each node on. So it should be extremely easy and straightforward to manage that bit. I think we had set up separate payment processors for each domain, as well (this may have been a custom module, IIRC), so that piece is doable as well. Cheers, -- Ian Bezanson Bezanson IT Solutions irb@bits.co +1.902.442.8392 On 2010-10-20, at 10:23 AM, jeff@ayendesigns.com wrote:
Well, so far that sounds doable, that the only development would be simulating separate books based on the sku.
If I can 'fudge' separate catalogs by controlling which store the item appears on, and separating each store's items out for reporting later, that could work. The one stumbling block would seem to be payment, which I don't think can be overridden by product, and possibly shipping, which I think cannot either other than as flat-rate groupings.
The payment part interests me on two levels, because I'd started the module uc_gateway_mediation and one of the requests is that it mediate based on currency, that is, choose the online merchant to use based on the currency in effect for that location.
I'll contact you for a link if you think it will show me something, given that I'd only be looking at it from one country, and would not be seeing the admin side at all.
Jeff
On 10/20/2010 09:02 AM, Ian Bezanson wrote:
In the spirit of keeping my response on the list...
Jeff, you can contact me privately if you want a link to the site in question. It was done under another company I worked with, so I don't want to take open credit for it :)
-- Ian Bezanson Bezanson IT Solutions irb@bits.co +1.902.442.8392
On 2010-10-20, at 9:56 AM, Ian Bezanson wrote:
I'm trying to remember, exactly :) The one we'd done was actually the latter case you describe. It was for a Jewelry company, based out of Halifax, NS, Canada with an online presence in Canada, US, Australia and a few other countries. We built the system, off of a single install so that each product could display in a single country, or all countries. I believe that the SKU was shared as well. I don't think we'd used the Ubercart Domain Access module, but it sounds like just the ticket, as it will label a purchase of any SKU with the appropriate domain it was purchased under. So.. I'm guessing the only custom-ish thing you may need to do is build an admin view to show reports per country, if that isn't a part of said module.
So, long and short - if Widget was set as SKU 001 and was configured to be shown in US, Canada but NOT Mexico (let's say), it will appear on the Canadian and US domains, but would not show up as part of the Mexican storefront. If you purchased from either US/Can, it will come through with the single SKU, marked somewhere in the system with that country.
Not sure if that clarifies or helps :/
-- Ian Bezanson Bezanson IT Solutions irb@bits.co +1.902.442.8392
Right. What I meant is that it's not 'really' separate product catalogs, such as, for example, having a separate catalog taxonomy for each location, that it's one big catalog that appears (fudged) to be separate catalogs via controlling the visibility of each node. On 10/20/2010 09:37 AM, Ian Bezanson wrote:
Oh sorry... let me rephrase a bit. No need, whatsoever to fudge the catalogs by domain, that's actually part of the domain access modules. You have the ability to "show on all domains" or pick specific domains to show each node on. So it should be extremely easy and straightforward to manage that bit. I think we had set up separate payment processors for each domain, as well (this may have been a custom module, IIRC), so that piece is doable as well.
Cheers,
I'll cautiously agree with that sentiment :) -- Ian Bezanson Bezanson IT Solutions irb@bits.co +1.902.442.8392 On 2010-10-20, at 10:40 AM, jeff@ayendesigns.com wrote:
Right. What I meant is that it's not 'really' separate product catalogs, such as, for example, having a separate catalog taxonomy for each location, that it's one big catalog that appears (fudged) to be separate catalogs via controlling the visibility of each node.
On 10/20/2010 09:37 AM, Ian Bezanson wrote:
Oh sorry... let me rephrase a bit. No need, whatsoever to fudge the catalogs by domain, that's actually part of the domain access modules. You have the ability to "show on all domains" or pick specific domains to show each node on. So it should be extremely easy and straightforward to manage that bit. I think we had set up separate payment processors for each domain, as well (this may have been a custom module, IIRC), so that piece is doable as well.
Cheers,
participants (2)
-
Ian Bezanson -
jeff＠ayendesigns.com