API Version 2
  • API V2 Overview
  • Category
    • Company
      • Customers
        • Orders
          • Pages
            • Page Templates
              • Products
                • Purchase Orders
                  • SKUs
                    • Support Tickets
                      • Tax Regions
                        • Vendors
                          • Warehouses
                            API Documentation

                            skus

                            Type List
                            List SKUs
                            URL http://{domain}/api/v2/SKUs.json
                            Accepts Filters Yes
                            Output Attributes
                            No


                            List SKUs

                            Gets the filtered LIST of SKUs. Using this API one can retrieve limited data on the SKUs which have been input into Lead Commerce. This LIST contains the fields ID, SKU, price, cost, status and product data block for each SKU. The ID is the primary key identifier for SKUs in Lead Commerce. The SKU (aka stockkeeping unit), is an alphanumeric identifier for a particular product. The status is the status of the SKU. The product data block includes the ID, Display ID and name of the product.
                            Filters
                            Filter the SKUs into a LIST. SKU Attributes are available as a filter. Attributes are user defined customizable fields which use graphical control elements such as Text Box, Checkbox and Drop Down Menu.
                            Parameter Type Rules Example
                            status int 0,1 or 2
                            1
                            price_max float Maximum price range 100
                            price_min float Minimum price range 20
                            modify_start date
                            1431377356
                            modify_end date
                            1431377356
                            Pagination
                            Parameters can be added to the CURL call to paginate the List. The maximum limit is 250. By default, this limit is set to 100.
                            Parameter Type Default Example
                            limit int 1 2
                            page int 1 5

                            Response

                            Example product JSON returned
                            {
                              "code": "200",
                              "data": [
                                {
                                  "id": "40",
                                  "sku": "20013",
                                  "price": "34.95",
                                  "cost": "19.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "14",
                                      "display_id": "20013",
                                      "name": "Updated Graphic T-Shirt"
                                    }
                                  ]
                                },
                                {
                                  "id": "39",
                                  "sku": "20012-0003",
                                  "price": "12.95",
                                  "cost": "5.25",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "13",
                                      "display_id": "20012",
                                      "name": "Bike Paint (Quart)"
                                    }
                                  ]
                                },
                                {
                                  "id": "38",
                                  "sku": "20012-0002",
                                  "price": "12.95",
                                  "cost": "5.25",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "13",
                                      "display_id": "20012",
                                      "name": "Bike Paint (Quart)"
                                    }
                                  ]
                                },
                                {
                                  "id": "37",
                                  "sku": "20012-0001",
                                  "price": "12.95",
                                  "cost": "5.25",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "13",
                                      "display_id": "20012",
                                      "name": "Bike Paint (Quart)"
                                    }
                                  ]
                                },
                                {
                                  "id": "36",
                                  "sku": "20011-0003",
                                  "price": "249.50",
                                  "cost": "145.90",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "12",
                                      "display_id": "20011",
                                      "name": "Custom Bike"
                                    }
                                  ]
                                },
                                {
                                  "id": "35",
                                  "sku": "20011-0002",
                                  "price": "249.50",
                                  "cost": "145.90",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "12",
                                      "display_id": "20011",
                                      "name": "Custom Bike"
                                    }
                                  ]
                                },
                                {
                                  "id": "34",
                                  "sku": "20011-0001",
                                  "price": "249.50",
                                  "cost": "145.90",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "12",
                                      "display_id": "20011",
                                      "name": "Custom Bike"
                                    }
                                  ]
                                },
                                {
                                  "id": "33",
                                  "sku": "20010",
                                  "price": "99.99",
                                  "cost": "62.00",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "11",
                                      "display_id": "20010",
                                      "name": "Bike Frame (Non Painted)"
                                    }
                                  ]
                                },
                                {
                                  "id": "32",
                                  "sku": "20009",
                                  "price": "52.04",
                                  "cost": "29.00",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "10",
                                      "display_id": "20009",
                                      "name": "Bike Rims"
                                    }
                                  ]
                                },
                                {
                                  "id": "31",
                                  "sku": "20008",
                                  "price": "19.99",
                                  "cost": "7.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "9",
                                      "display_id": "20008",
                                      "name": "Bike Tires"
                                    }
                                  ]
                                },
                                {
                                  "id": "30",
                                  "sku": "20007",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "8",
                                      "display_id": "20007",
                                      "name": "Bike Fasteners"
                                    }
                                  ]
                                },
                                {
                                  "id": "29",
                                  "sku": "20006",
                                  "price": "68.00",
                                  "cost": "35.80",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "7",
                                      "display_id": "20006",
                                      "name": "Bike Handlebars"
                                    }
                                  ]
                                },
                                {
                                  "id": "28",
                                  "sku": "20005",
                                  "price": "27.99",
                                  "cost": "14.50",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "6",
                                      "display_id": "20005",
                                      "name": "Bike Seat"
                                    }
                                  ]
                                },
                                {
                                  "id": "27",
                                  "sku": "20004",
                                  "price": "13.60",
                                  "cost": "7.50",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "5",
                                      "display_id": "20004",
                                      "name": "Bike Brakes"
                                    }
                                  ]
                                },
                                {
                                  "id": "26",
                                  "sku": "20003",
                                  "price": "15.82",
                                  "cost": "8.50",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "4",
                                      "display_id": "20003",
                                      "name": "Bike Gear"
                                    }
                                  ]
                                },
                                {
                                  "id": "25",
                                  "sku": "20002",
                                  "price": "14.00",
                                  "cost": "8.00",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "3",
                                      "display_id": "20002",
                                      "name": "Bike Chain"
                                    }
                                  ]
                                },
                                {
                                  "id": "24",
                                  "sku": "20001-0012",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "23",
                                  "sku": "20001-0011",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "22",
                                  "sku": "20001-0010",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "21",
                                  "sku": "20001-0009",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "20",
                                  "sku": "20001-0008",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "19",
                                  "sku": "20001-0007",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "18",
                                  "sku": "20001-0006",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "17",
                                  "sku": "20001-0005",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "16",
                                  "sku": "20001-0004",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "15",
                                  "sku": "20001-0003",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "14",
                                  "sku": "20001-0002BMT",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "13",
                                  "sku": "20001-0001AXP",
                                  "price": "32.99",
                                  "cost": "6.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "2",
                                      "display_id": "20001",
                                      "name": "Fleece Curved Pocket Hoodie"
                                    }
                                  ]
                                },
                                {
                                  "id": "12",
                                  "sku": "20000-0012",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "11",
                                  "sku": "20000-0011",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "10",
                                  "sku": "20000-0010",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "9",
                                  "sku": "20000-0009",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "8",
                                  "sku": "20000-0008",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "7",
                                  "sku": "20000-0007",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "6",
                                  "sku": "20000-0006",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "5",
                                  "sku": "20000-0005",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "4",
                                  "sku": "20000-0004",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "3",
                                  "sku": "20000-0003",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "2",
                                  "sku": "20000-0002BXW",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                },
                                {
                                  "id": "1",
                                  "sku": "20000-0001",
                                  "price": "22.99",
                                  "cost": "8.95",
                                  "status": "1",
                                  "product": [
                                    {
                                      "id": "1",
                                      "display_id": "20000",
                                      "name": "Modern-Fit Vest"
                                    }
                                  ]
                                }
                              ]
                            }
                            

                            Start your free, no-risk trial today.