Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Emailing invoice to distributor


Guest

Recommended Posts

I'm trying to find a better way to send an email to a distributor with the customers order. Right now, I just copy and paste into an email from the admin, but this doesn't paste correctly and is rather time consuming. Does anyone know of a mod or simpler way to email an order/invoice to a third party?

 

Thanks

Josef

Link to comment
Share on other sites

Thanks Mikedjr, but like rseigel said, we do have to deal with at least 2-3 distributors. I did think about just adding them, but that brings up other issues.

Link to comment
Share on other sites

so, add a new field to the product table, add a shippers admin function (along manufacturer lines), then have a drop down for every product that allows you to select its distributor. Define the associated email address and include it in the Invoice Send routine.

Link to comment
Share on other sites

so, add a new field to the product table, add a shippers admin function (along manufacturer lines), then have a drop down for every product that allows you to select its distributor.  Define the associated email address and include it in the Invoice Send routine.

 

or rather than including as a CC address in the routine that sends the Invoice to the customer, send a separate invoice, including your info (name, acct #, etc)

Link to comment
Share on other sites

Hey bud,

 

I have my store set up to email multiple distributors with the option of sending you the email instead if the order total is too high (to weed out potentially fraudulent orders). It involved a lot of custom coding and adding fields to several parts of the DB. I even had to tweak Easypopulate so I could manipulate the extra DB fields in Excel.

 

On each item you'll need a field to indicate which distributor something is. I used numbers to simplify the programming (you can use for loops then when adding to the cart). I also added fields for their Net Cost and SKU. (That's not everything, but all I can remember right now.)

 

I would offer a module, but there is too much stuff hardcoded into the store and people would likely screw things up with all of the modifications I made. It's not PnP as many of the other add-ons out there. That's not to say that my way of programming it is the best way, but I frankly don't think you can make a module to do this that doesn't require a lot of patches to the base code of the store. THen it's also a lot tougher to just upgrade the store later with the custom DB, fields and add-ons.

 

If you'd like me to send you my entire store code (it's based on a very recent snapshot) and a sample DB, you can contact me off list. Not to be rude, I might charge for it, at least to support it, because it took me a long time to put together and I have a feeling that you'll be asking me many questions about how it is set up and my time is pretty valuable these days.

 

But hey, if you want to bang it out yourself, go for it. If you do a lot of orders it might be worth the time. It took me about a month in my spare time, though I do have a some programming experience.

 

-Dave :wink:

Link to comment
Share on other sites

  • 5 months later...

We have 18 distributors in which our product comes from. We are trying to get automated so that once order is complete it mails my distrib ship to info manufacture model and qty nad that is it.

We are working on integrating a module that handles all checking for product price

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...