Check for amazon seller prime order in desktop script

I have a desktop based script which allocated my shipping services.

We have just started with Amazon seller fulfilled prime and need to programatically check for this. Prime orders are given "tag 6" by linnworks by default and there is also a IsPrime tax in the xml but I cannot find a way to reference these within the desktop open order script.

Is there any documentation for these scripts? I know they are unsupported now and I'm quite happy to develop it myself but without documentation I'm just guessing at references.


Many thanks

It would also help to be able to identify if the order was made between 14:00 on Thursday and 13:59 on Friday as this requires saturday delivery.

I am using Linnworks.net, but having to write some scripts for that, I found a lot of Desktop script documentation.  Not sure if you have been to the below link:


https://desktop.linnworks.com/Doc/Order_Scripts_Sample_Code


Also, if you are looking for the full SQL database so you can reference certain table fields, you can run the below query in SQL Server Management Studio, or in Desktop if it has a custom script report capability like Linnworks.net has.  It was extremely helpful to me being able to reference anything in the database.  Hope this helps.


SELECT TABLE_SCHEMA ,

       TABLE_NAME ,

       COLUMN_NAME ,

       ORDINAL_POSITION ,

       COLUMN_DEFAULT ,

       DATA_TYPE ,

       CHARACTER_MAXIMUM_LENGTH ,

       NUMERIC_PRECISION ,

       NUMERIC_PRECISION_RADIX ,

       NUMERIC_SCALE ,

       DATETIME_PRECISION

FROM INFORMATION_SCHEMA.COLUMNS;


Brian


Login to post a comment