Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 03-06-2019 04:38:05

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Setting Up Dropshipping Rules

We would like to use the dropshipping features in K9. Do you already have instructions on using this somewhere?

Can we setup inventory-item specific rules for domestic-only dropshipping when the quantity requested exceeds stock in local warehouse e.g.

Custom range of zone-based shipping options
Custom same day despatch cut-off times
Custom free delivery order value

There are so many settings in K9 now that it is difficult to know where to start e.g. Inventory Type, Delivery Method, Vendor, Warehouse Location, etc.

Just trying to get a feel for what is possible out of the box so we can decide how to proceed with minimum of custom coding.

Last edited by sdn (03-06-2019 04:45:45)


Simon

Offline

 

#2 03-06-2019 08:19:21

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Setting Up Dropshipping Rules

This is available, however a bit outdated:

https://kryptronic.com/DEVMANUAL/Invent … ipping.php

We still have a few bits to handle on the documentation prior to public launch this month, and inventory/vendor changes from 9.0.2 need to be addressed in updated docs.  So I'll outline some points below.

- Set up your vendors correctly, using Store / Inventory / Vendors.  This is where you'd put the location for each vendor, which ends up being where your inventory items are being shipped from.

- Make sure your inventory items are tied to appropriate vendors using the Vendor field (in the Accounting tab) for Inventory Items under Store / Inventory / Inventory Items.  Also, change the Inventory Type to 'Local Warehouse Inventoried / Dropshipped (When Out)', and check your Local Inventory Level to make sure you have the right local stock listed.

When items like this go out of stock locally, dropshipping from the vendor location kicks in.  This means your shipments will be split, so if you're using custom shipping, it will be easy to isolate the different vendor shipments based on origin postal code (assuming they're different for each vendor).  That's where you can start to apply things like free shipping thresholds on dropship-only items, etc.

Perhaps you could lay out what you need to accomplish, and we could provide info on the best way to achieve what you need.


Nick Hendler

Offline

 

#3 03-06-2019 09:37:49

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Setting Up Dropshipping Rules

Thanks for the info.

There are quite a few variables that we need to account for like

1. if an order is just for dropshipped items only or a mixture of local-warehouse and dropshipped
2. if the latter, whether the value of local-warehouse and dropship products ordered qualify for free delivery
3. if expedited delivery has been selected (if not, we may order the shortage in and despatch all items in a single parcel to save carriage costs)
4. if we are over the dropshippers carriage paid threshold

Our primary dropshipper has some criteria we would like to account for like

1. 2pm cut-off time for same day despatch
2. free delivery to UK mainland destinations when products ordered exceed a certain value (based on the dropshippers selling price to us not our customers buying price of course)

Given how complicated the above sounds, could you confirm if we could start by doing this:

1. initiate a dropship when the contents of the basket are just from the dropshipper
2. offer free delivery if contents exceed dropshippers carriage paid threshold and/or next day delivery options if the Mon-Fri 2pm cut-off time has not passed
3. Not display expedited delivery options for a mixed basket of local and dropship items

Last edited by sdn (03-06-2019 09:51:32)


Simon

Offline

 

#4 03-07-2019 08:26:05

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Setting Up Dropshipping Rules

Complicated, yes. 

You should understand that when K9 processes an order with dropship item(s) in it, those dropship item(s) are not set up to be shipped locally.  The expected procedure would be for you to use the Order Manager for the order to access Inventory and Dropship Controls to manage how the inventory will be shipped.  For any dropship items in the order, you will have the option to create a Purchase Order.  You should do that, which sets you up to order the inventory to be shipped to the customer from the vendor via Purchase Order.  The vendor will receive your PO via email, fulfill it, then report tracking back to you.  You can either receive the PO in K9 and enter tracking info (and that will ship the items and complete the order) ~OR~ you can mark the items as shipped and enter tracking info (and that will close out the PO for those items).

Inventory and Dropship Controls allows you to flip the inventory source to dropship/local for all items in the order (which have not been shipped).  There you could take an order with a mix of dropship and local items and make them all dropship before issuing a PO.  Or make a mixed order all local inventory.  Or whatever you like.

I think you should try to work within the system here and accept mixed orders because you can change them after the fact.  Set your inventory up so they have proper vendor assignments, and set them up so they dropship when out of local inventory.  This will create mixed shipments in orders (some items local, some dropship).  If all items are assigned to use a custom shipping script for ratings (even if that script uses realtime or zone rates, mind you), we can do a ton to meet your requirements like adjusting free shipping thresholds, etc.  The only thing we'd require is that your local warehouse postal code (adjusted under Store / Component / Settings / Shipping Settings) is different than your vendor postal codes (adjusted under Store / Inventory / Vendors).

We can do things like adjust delivery cutoff times and free shipping thresholds, remove expedited options, change shipping options, check costs, recognize mixed shipments, etc, from within custom shipping scripts - so that's the direction you should head here.  The 2PM cutoff change for same-day dispatch is an issue, however unless you're using realtime delivery estimates, it may just be a display issue.

The big question is, right now, how are your inventory items set up to ship?  If they are using a custom shipping script, can you post it?


Nick Hendler

Offline

 

#5 03-12-2019 04:21:57

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Setting Up Dropshipping Rules

We currently use zone-based shipping for all inventory items so no custom shipping rules. I need some time to get my head around the above and decide if it is worth pursuing.

Where is the time set under "Shipping Times: Ship Cutoff Time" in "Dashboard / Store / Component / Settings" used? Is it only for real-time calculations? We cannot pull that into a custom shipping script right?

Last edited by sdn (03-12-2019 04:26:17)


Simon

Offline

 

#6 03-12-2019 06:54:40

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Setting Up Dropshipping Rules

The shipping cutoff time is determined prior to all ratings, based on the global setting you referenced, as well as day of week, and holidays.  After calculated, the shipping cutoff time is globalized as:

$this->globals('ecom.ship_shipepoch')

And is available (and could be changed) using custom shipping scripts.  Additionally, zone-based shipping can be calculated from within a custom shipping script (by attaching to the zone-based function from within the custom script).


Nick Hendler

Offline

 

#7 03-13-2019 03:16:57

sdn
Member
From: UK
Registered: 05-29-2007
Posts: 882

Re: Setting Up Dropshipping Rules

OK that sound promising.

Is there any sample code for using ecom.ship_shipepoch and zone-based shipping within a custom shipping script?

Is the Order Manager you mentioned above an x-mod or do you just mean the standard order centre management interface?

Last edited by sdn (03-13-2019 03:58:03)


Simon

Offline

 

#8 03-13-2019 07:01:46

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Setting Up Dropshipping Rules

This is a really basic custom script that simply takes input and gets zone rates for it.  Ship epoch adjustment is in there too.

Code:

<?php 

// +--
// | Variable definition and ECOM_Ship object load
// +-- 

$info      =  $this->globals('ecom.customship');
$custom    =  array();

$ECOM_Ship =& $this->quick_object('ECOM_Ship','ecom');

// +--
// | Set shipping epoch - three days from now
// +-- 

$shipepochorig = $this->globals('ecom.ship_shipepoch');
$shipepochnew  = ($shipepochorig + (3 * 24 * 60 * 60));

$this->globals('ecom.ship_shipepoch',$shipepochnew);

// +--
// | Define zone input, exec zone function, handle result
// +-- 

$zonearray  = array('weight' => $info['weight'], 'total' => $info['total'], 'country' => $info['country'], 'postalcode' => $info['postalcode']);
$zone_rates = $ECOM_Ship->getrates_zone($zonearray,$this->build_packages($packageitems_all[$delgroup]));

foreach ($zone_rates as $num => $rateinfo) {$custom[$rateinfo['name']] = $rateinfo['amount'];}

// +--
// | Reset shipping epoch to original value, globalize result
// +-- 

$this->globals('ecom.ship_shipepoch',$shipepochorig);
$this->globals('ecom.customship_response',$custom);

?>

Yes, I am referencing the Order Manager, which is a stock function in K9 for managing orders found under Store / Orders / Order Center.  View a specific order and you will be using it's Order Manager.


Nick Hendler

Offline

 

Board footer