title | description |
---|---|
Steampipe Table: salesforce_product - Query Salesforce Products using SQL |
Allows users to query Products in Salesforce, providing detailed information about each product, including its standard and custom fields. |
Salesforce Products are used to represent the items you sell. They can be goods, services, or digital content that are part of your business model. Products are typically associated with Opportunities or Quotes in Salesforce.
The salesforce_product
table provides insights into Products within Salesforce. As a Sales or Business Analyst, explore product-specific details through this table, including standard and custom fields. Utilize it to uncover information about products, such as their associated Opportunities or Quotes, and the verification of custom fields.
Important Notes
- If the
naming_convention
configuration argument is set toapi_native
, please see API Native Examples. - If the naming_convention parameter is set to api_native in the config file, then the table and column names will match what’s in Salesforce. For instance, the query
select id, name from salesforce_product
would becomeselect "ID", "Name" from "Product2"
.
Explore which products in your Salesforce inventory are active and who created them. This information can be useful for auditing purposes and to understand the distribution of product responsibilities within your team.
select
id,
name,
family,
is_active,
created_by_id,
quantity_unit_of_measure,
stock_keeping_unit
from
salesforce_product;
select
id,
name,
family,
is_active,
created_by_id,
quantity_unit_of_measure,
stock_keeping_unit
from
salesforce_product;
Discover the segments that consist of inactive products in your Salesforce database. This can help you identify which products are not currently in use, allowing you to make informed decisions about inventory management and product offerings.
select
id,
name,
family,
is_active,
created_by_id,
quantity_unit_of_measure,
stock_keeping_unit
from
salesforce_product
where
not is_active;
select
id,
name,
family,
is_active,
created_by_id,
quantity_unit_of_measure,
stock_keeping_unit
from
salesforce_product
where
is_active = 0;
If the naming_convention
config argument is set to api_native
, the table and column names will match Salesforce naming conventions.
Explore which products are active and in stock by assessing key attributes such as product ID, name, and family. This can help in managing inventory and understanding product performance.
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2";
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2";
Discover the segments that contain inactive products in the inventory to better manage stock and potentially discontinue or replenish certain items.
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2"
where
not "IsActive";
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2"
where
"IsActive" = 0;
Explore which products have been archived in your inventory, allowing you to keep track of items no longer actively sold or in circulation.
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2"
where
"IsArchived";
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2"
where
"IsArchived";
Uncover the details of products that have been removed from your inventory. This is useful for tracking product lifecycle and managing stock levels effectively.
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2"
where
"IsDeleted";
select
"ID",
"Name",
"Family",
"IsActive",
"StockKeepingUnit"
from
"Product2"
where
"IsDeleted";