I'm glad to hear you got it working. If others want to explore an alternative solution, here is more specific info on the feature included in Worldship 8.0, which I should have included in my earlier post. Laziness got the better of me--sorry.

In the Worldship 8.0 help files, look for "Hands-off shipping". It gives a good description of how the feature works, along with detailed instructions for setting it up.

Again, I haven't yet set it up myself, but, judging by the description, it will automatically import at your specified interval whatever records are in the upsworld.dbf table. The interval can be as brief as one second, apparently.

You would want turn on the option to have Worldship check the key field to make sure it doesn't import the same record twice. I believe the key field should be the Pkg_ref5 field in Upsworld.dbf which corresponds to the segment ID number (or is it the box ID number?) in MOM, if memory serves.

Best of luck to all.

Evan Frink
Journeyworks Publishing

The latest version of WorldShip--8.0 if I recall correctly--includes a new feature for doing an automatic import at specified intervals, which could be every few minutes if you want. I haven't had time to set this up yet, but it seems like the simplest way to get the results you described.

If you decide to go this route, I would be interested to hear how it works for you.

Good luck!

Evan Frink
Journeyworks Publishing

Dydacomp has very easy-to-follow set up documentation, both for the export of data from MOM to Worldship and for the import of tracking numbers from Worldship to MOM. Just call or email tech support and ask them to email the docs to you.

Evan Frink
Journeyworks Publishing

I'm in the process of integrating UPS and MOM. I got it all setup as per the documentation the UPS tech brought, but wasn't satisfied with the results. The way it worked required too much manual importing and exporting and we were looking for something much simpler. I looked into the UPS HTTP setup too, which looked more automated, but still wasn't sure it'd fit well with our setup.

I ended up setting it up very similar to how Fedex set their system up for us. I used the database maps in Worldship to import customer information into Worldship via ODBC. They can type in an invoice number and it populates the address, etc fields. That part works mostly just like we wanted, still a few kinks to work out.

Now, I need to get the tracking number exported back into MOM. They have our Fedex system setup so that it automatically edits the MOM DBF file(s) for the tracking information. I can't find which file(s) it's editing, but I think BOX.DBF is where the info should be going?

Anyone had any luck setting something like this up? If I can't do it the way Fedex has it, then I'll have to export to a CSV file and figure out a way to automate that, so any hints on that direction would also be appreciated!

Thank you,

Susie

Page 1 gives you info about orders that were entered into MOM on the chosen date, and page 2 gives you info about orders that were invoiced on that date. If you invoice your orders on the same day you enter them (normally we don't), then the numbers may match up. However, if an order is on hold, a credit card got declined, etc. then there will be some discrepancy.

Hope that helps.

Evan Frink
Journeyworks Publishing

Can anyone give me an explanation of what page 1 of the Daily Order Activity Report tells me? That the section for "Order Entered by Method of Payment." I've put a day's worth of orders on a spreadsheet and I still can't figure out what the numbers on page 1 represent. Some days it's higher than the page 2 numbers, some days it's not.

In the US version, we ahve a feature called order promotions, located under Maintain-->Advertising Information-->Order Promotions. I think that might be what you are looking for, it it's available to you.

Best of luck to you.

Evan Frink
Journeyworks Publishing

Hi there,

We are a gift retail company based in the UK, we have recently purchased MOM to go alongside our new site, www.thenaturalworld.com . Still trying to get to grips with a few things, not finding the manual particularly useful.

We are setting up a 20% off promotion on our website which, of course we want MOM to reflect. Not found a particularly good way of doing this, set to a schedule. Have looked at the product maintenence and the Special Price Information screen. It's all a little bit confusing.  :blink:

Can anyone tell me the best way to set up a scheduled promotion on unrelated products?

Thank you very much

Ryan Greenaway

In 5.3 our shipping table include rates for international parcel post, both surface and air. They do not include rates for other international services, though.

Evan Frink
Journeyworks Publishing

Anyone?

Matt,

If you look at price.dbf, you will see that it has fields for Ctype, Ctype2, Ctype3. I believe these are populated when a given price for a given item is dependent on the customer type.

I am a novice, too, so I suggest manually creating a few customer-type-dependent price levels through MOM's interface, then seeing how they show up in the table. I don't know if this is linked to any other tables, so caveat manipulator.

Best of luck,

Evan Frink
Journeyworks Publishing

Hello there.

I am currently trying to set up MOM to have different pricing structures for wholesaler, jobber and retail. I understand through cryptic conversations with MOM tech support (which ended Fri for us BTW) that customer type codes can distinguish these levels. Say type code1 we specify W,J, and R for different pricing structures, what .dbf can I populate to relate to those different customer codes?

It seeems to me that there is provision for different price lists (not formulas, but lists) in the catalog code input, where is the list kept and therefore populated in dbwin?

I am an obvious novice, but I'm not dense (well, OK, perhaps I am al ittle dense). I am just really having a hard time wrapping my head around how the engine functions to index different pricing levels. Any help would be appreciated. If it's been discussed before, forgive me. I did a search in the archives and didnt find what I need.

I understand I can manually do it one-at-a-time, but that is not practical in the volume of parts we need to keep track of and most suppliers supply us with a digital price list (.xls) already.

Thanks in Advance,

Matt Sheppard
The Racer's Group
Petaluma, CA