31 vAPI_add_edit_amazon_item
Add or edit amazon item information
Inputs:
| Input Name |
Required |
Type |
Max Length |
Details |
| $arg_array |
YES |
ASSOC |
-- |
Details follow: |
| $arg_array / company_id |
YES |
INT |
-- |
references: company_master.company_id |
| $arg_array / amazon_sku |
YES |
STRING |
32 |
references: amazon_items.amazon_sku |
| $arg_array / amazon_asin |
NO |
STRING |
32 |
references: amazon_items.amazon_asin |
| $arg_array / product_name |
NO |
STRING |
-- |
references: amazon_items.product_name |
| $arg_array / price |
NO |
NUMERIC |
-- |
references: amazon_items.price |
| $arg_array / item_code |
YES |
STRING |
32 |
references: item_master.item_code |
| $arg_array / quantity_override |
NO |
NUMERIC |
-- |
references: amazon_items.quantity_override |
| $arg_array / lead_time_override |
NO |
NUMERIC |
-- |
references: amazon_items.lead_time_override |
| $arg_array / suspend_updates |
NO |
BOOLEAN |
-- |
references: amazon_items.suspend_updates |
| $dbconn |
YES |
DBHANDLE |
-- |
Database Connection |
Outputs:
| Output Name |
Type |
Details |
| $record |
ASSOC |
Details follow: |
| $record / action |
STRING |
ADD: New record was added |
|
|
EDIT: Existing record was updated |
Error Codes:
| PGQUERY |
Failed SQL query |
| CHECKPOINT |
Error when calling the checkpoint function |
Called API Functions:
logAPI:vAPI_checkpoint_table_revision
Return to:
Item_API Reference
There are no comments on this page. [Add comment]