Monkeybread Software - MBS FileMaker Plugin: magento older

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

magento older

All examples are included with download of MBS FileMaker Plugin.

magento older.fmp12

Overview
Tables	1
Relationships	3
Layouts	1
Scripts	10
Value Lists	0
Custom Functions	0
Custom Menus	33

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	<Missing Layout>
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
CURL	24 fields defined, 1 record	CURL

Fields

Table Name: CURL - 24 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
Result	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login ProductList Product Info Customer Info Order Info OrderList OrderList Filter Status SetNewPrice SetNewNameAndPrice Clear
Text	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login SetNewPrice SetNewNameAndPrice Clear
SessionID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login ProductList Product Info Customer Info Order Info OrderList OrderList Filter Status SetNewPrice SetNewNameAndPrice Clear
debug	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login ProductList Product Info Customer Info Order Info OrderList OrderList Filter Status SetNewPrice SetNewNameAndPrice Clear
URL	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login ProductList Product Info Customer Info Order Info OrderList OrderList Filter Status SetNewPrice SetNewNameAndPrice
UserName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login
Password	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login
All Products	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		ProductList Clear
Product ID_o_SKU	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Product Info SetNewPrice SetNewNameAndPrice
Product Info	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Product Info Clear
orderList	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		OrderList OrderList Filter Status Clear
NewPrice	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		SetNewPrice SetNewNameAndPrice
HTTP Response	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Login ProductList Product Info Customer Info Order Info OrderList OrderList Filter Status SetNewPrice SetNewNameAndPrice Clear
customerID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Customer Info
Customer Info	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		Customer Info
name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL
NewName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		CURL		SetNewNameAndPrice
orderIncrementId	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German			CURL=CURL\|order	Order Info
orderDetail	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German				Order Info
orderItemSku	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
orderItemName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
orderItemPrice	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German
__ID_orderItem	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German			CURL=Curl\|orderitem
customerName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German

Relationship: CURL=Curl|orderitem

Table Occurrence	CURL		Curl\|orderitem
Field	__ID_orderItem	=	<Missing Field>
Source Table	CURL		<Missing Base Table>
Source File	magento older.fmp12		magento older.fmp12
Allow creation of records via this relationship	Off		On
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Relationship: Curl|order|orderitem=CURL|order

Table Occurrence	Curl\|order\|orderitem		CURL\|order
Field	<Missing Field>	=	<Missing Field>
Source Table	<Missing Base Table>		<Missing Base Table>
Source File	magento older.fmp12		magento older.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Layout Hierarchy

Save record changes automatically

Show field frames when record is active

Show field frames only on current record

Show current record indicator in List View

17 Regular Fields
9 Group Buttons

CURL

Field Name: CURL::Result

Layout Name:

CURL

Top: 29 pt
Left: 138 pt
Bottom: 43 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::Text

Layout Name:

CURL

Top: 71 pt
Left: 138 pt
Bottom: 283 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::SessionID

Layout Name:

CURL

Top: 292 pt
Left: 138 pt
Bottom: 306 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::URL

Layout Name:

CURL

Top: 11 pt
Left: 138 pt
Bottom: 25 pt
Right: 553 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::debug

Layout Name:

CURL

Top: 24 pt
Left: 570 pt
Bottom: 476 pt
Right: 925 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::UserName

Layout Name:

CURL

Top: 311 pt
Left: 138 pt
Bottom: 325 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::Password

Layout Name:

CURL

Top: 329 pt
Left: 138 pt
Bottom: 343 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::All Products

Layout Name:

CURL

Top: 347 pt
Left: 138 pt
Bottom: 361 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::Product ID_o_SKU

Layout Name:

CURL

Top: 365 pt
Left: 138 pt
Bottom: 379 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::Product Info

Layout Name:

CURL

Top: 383 pt
Left: 138 pt
Bottom: 397 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::orderList

Layout Name:

CURL

Top: 401 pt
Left: 138 pt
Bottom: 433 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::NewPrice

Layout Name:

CURL

Top: 437 pt
Left: 138 pt
Bottom: 451 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::HTTP Response

Layout Name:

CURL

Top: 48 pt
Left: 138 pt
Bottom: 62 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::customerID

Layout Name:

CURL

Top: 456 pt
Left: 138 pt
Bottom: 470 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::Customer Info

Layout Name:

CURL

Top: 474 pt
Left: 138 pt
Bottom: 488 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::name

Layout Name:

CURL

Top: 491 pt
Left: 138 pt
Bottom: 505 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: CURL::NewName

Layout Name:

CURL

Top: 509 pt
Left: 138 pt
Bottom: 523 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Type:

Text: Login

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 292 pt
Left: 402 pt
Bottom: 317 pt
Right: 535 pt

Anchoring: Left, Top

Perform Script [ “Login” ]

Scripts:

Button Properties

Coordinates

Script/Script Step

Type:

Text: Trace on

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 584 pt
Left: 402 pt
Bottom: 609 pt
Right: 535 pt

Anchoring: Left, Top

Set Variable [ $result; Value:MBS("Trace") ]

Button Properties

Coordinates

Script/Script Step

Type:

Text: List all Products

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 340 pt
Left: 402 pt
Bottom: 365 pt
Right: 535 pt

Anchoring: Left, Top

Perform Script [ “ProductList” ]

Scripts:

ProductList

Button Properties

Coordinates

Script/Script Step

Type:

Text: Product Info

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 370 pt
Left: 402 pt
Bottom: 395 pt
Right: 535 pt

Anchoring: Left, Top

Perform Script [ “Product Info” ]

Scripts:

Product Info

Button Properties

Coordinates

Script/Script Step

Type:

Text: List all Orders

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 400 pt
Left: 402 pt
Bottom: 425 pt
Right: 535 pt

Anchoring: Left, Top

Perform Script [ “OrderList” ]

Scripts:

OrderList

Button Properties

Coordinates

Script/Script Step

Type:

Text: Set New Price

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 457 pt
Left: 402 pt
Bottom: 482 pt
Right: 535 pt

Anchoring: Left, Top

Perform Script [ “SetNewPrice” ]

Scripts:

SetNewPrice

Button Properties

Coordinates

Script/Script Step

Type:

Text: Clear

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 548 pt
Left: 402 pt
Bottom: 573 pt
Right: 535 pt

Anchoring: Left, Top

Perform Script [ “Clear” ]

Scripts:

Clear

Button Properties

Coordinates

Script/Script Step

Type:

Text: Set New Name and price

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 486 pt
Left: 400 pt
Bottom: 511 pt
Right: 537 pt

Anchoring: Left, Top

Perform Script [ “SetNewNameAndPrice” ]

Scripts:

SetNewNameAndPrice

Button Properties

Coordinates

Script/Script Step

Type:

Text: List pending Orders

Layout Name:

CURL

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 428 pt
Left: 402 pt
Bottom: 453 pt
Right: 535 pt

Anchoring: Left, Top

Perform Script [ “OrderList Filter Status” ]

Scripts:

OrderList Filter Status

OrderList Filter Status

Parent Folder: [simple]

Next Script: [ProductList]

Script Name	Login
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\"> <soapenv:Header/> <soapenv:Body> <urn:login soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <username xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::UserName ) & "</username> <apiKey xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Password ) & "</apiKey> </urn:login> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::Text; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $xml; Value:MBS( "XML.SubTree"; CURL::Text; "Body¶loginResponse¶loginReturn" ) ] If [ MBS("IsError") ] Set Field [ CURL::SessionID; "" ] Else Set Field [ CURL::SessionID; MBS( "XML.ExtractText"; $xml) ] End If #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::UserName CURL::Password CURL::Result CURL::HTTP Response CURL::Text CURL::debug CURL::SessionID
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Login]

Parent Folder: [simple]

Next Script: [Product Info]

Script Name	ProductList
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductList soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> </urn:catalogProductList> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::All Products; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::Result CURL::HTTP Response CURL::All Products CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [ProductList]

Parent Folder: [simple]

Next Script: [Customer Info]

Script Name	Product Info
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductInfo soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <productId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Product ID_o_SKU ) & "</productId> </urn:catalogProductInfo> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::Product Info; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::Product ID_o_SKU CURL::Result CURL::HTTP Response CURL::Product Info CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Product Info]

Parent Folder: [simple]

Next Script: [Order Info]

Script Name	Customer Info
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:customerCustomerInfo soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <customerId xsi:type=\"xsd:int\">" & MBS( "Text.EncodeToXML"; CURL::customerID) & "</customerId> </urn:customerCustomerInfo> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::Customer Info; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::customerID CURL::Result CURL::HTTP Response CURL::Customer Info CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Customer Info]

Parent Folder: [simple]

Next Script: [OrderList]

Script Name	Order Info
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:salesOrderInfo soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <orderIncrementId xsi:type=\"xsd:int\">" & MBS( "Text.EncodeToXML"; CURL::orderIncrementId) & "</orderIncrementId> </urn:salesOrderInfo> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::orderDetail; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::orderIncrementId CURL::Result CURL::HTTP Response CURL::orderDetail CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Order Info]

Parent Folder: [simple]

Next Script: [OrderList Filter Status]

Script Name	OrderList
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:salesOrderList soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> </urn:salesOrderList> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::orderList; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::Result CURL::HTTP Response CURL::orderList CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [OrderList]

Parent Folder: [simple]

Next Script: [SetNewPrice]

Script Name	OrderList Filter Status
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:salesOrderList soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <filters> <filter> <associativeEntity> <key>status</key> <value>pending</value> </associativeEntity> </filter> </filters> </urn:salesOrderList> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::orderList; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::Result CURL::HTTP Response CURL::orderList CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [OrderList Filter Status]

Parent Folder: [simple]

Next Script: [SetNewNameAndPrice]

Script Name	SetNewPrice
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductUpdate soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <product xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Product ID_o_SKU ) & "</product> <productData xsi:type=\"urn:catalogProductCreateEntity\"> <price xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::NewPrice ) & "</price> </productData> </urn:catalogProductUpdate> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::Text; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::Product ID_o_SKU CURL::NewPrice CURL::Result CURL::HTTP Response CURL::Text CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [SetNewPrice]

Parent Folder: [simple]

Next Script: [Clear]

Script Name	SetNewNameAndPrice
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	#Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL::URL) ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; "<soapenv:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:urn=\"urn:Magento\" xmlns:soapenc=\"http://schemas.xmlsoap.org/soap/encoding/\"> <soapenv:Header/> <soapenv:Body> <urn:catalogProductUpdate soapenv:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"> <sessionId xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::SessionID ) & "</sessionId> <product xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::Product ID_o_SKU ) & "</product> <productData xsi:type=\"urn:catalogProductCreateEntity\"> <name xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::NewName ) & "</name> <price xsi:type=\"xsd:string\">" & MBS( "Text.EncodeToXML"; CURL::NewPrice ) & "</price> </productData> </urn:catalogProductUpdate> </soapenv:Body> </soapenv:Envelope>") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"urn:Mage_Api_Model_Server_V2_HandlerAction\"") ] #RUN now Set Field [ CURL::Result; MBS("CURL.Perform"; $curl) ] #Check result Set Field [ CURL::HTTP Response; MBS("CURL.GetResponseCode"; $curl) ] Set Field [ CURL::Text; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ CURL::debug; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	CURL::URL CURL::SessionID CURL::Product ID_o_SKU CURL::NewName CURL::NewPrice CURL::Result CURL::HTTP Response CURL::Text CURL::debug
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [SetNewNameAndPrice]

Parent Folder: [simple]

Script Name	Clear
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	CURL
Scripts that use this script
Script Definition
Script Steps	Set Field [ CURL::SessionID; "" ] Set Field [ CURL::All Products; "" ] Set Field [ CURL::Product Info; "" ] Set Field [ CURL::orderList; "" ] Set Field [ CURL::debug; "" ] Set Field [ CURL::Text; "" ] Set Field [ CURL::Result; "" ] Set Field [ CURL::HTTP Response; "" ]
Fields used in this script	CURL::SessionID CURL::All Products CURL::Product Info CURL::orderList CURL::debug CURL::Text CURL::Result CURL::HTTP Response
Scripts used in this script
Layouts used in this script
Tables used in this script	CURL
Table occurrences used by this script	CURL
Custom Functions used by this script
Custom menu set used by this script

Download example: magento older

Used functions: