wp_posts
These are the main Product Columns and can be retrieved using get_post.
example: If I have a product with an ID of 83:
$product = get_post(83);
| Column Name | Description |
|---|---|
| ID | Product ID |
| post_content | Product Description |
| post_title | Product Name |
| post_name | Product Slug |
| post_status | Product Publishing Status (Draft, Publish, Trash) |
| post_type | Product Custom Post Type (wpsc-product) |
| post_name | Product Slug |
| post_parent | 0 if it is a normal product, ID of Parent Product if it is a variation |
wp_postmeta
These are the main available product meta data.. due to search limitations of serialized data, things like Price and SKU that can be required for searches are not placed inside the main _wpsc_product_metadata. If you are creating a new product_meta that does not necessarily need to be used for searches, place them into the _wpsc_product_metadata instead of into an entirely new product meta.
You can retrieve meta data through either get_post_meta; or get_product_meta;
examples: Say I have a product with an ID of 83 and I want to retrieve the price:
For get_post_meta;
$price = get_post_meta(83, '_wpsc_price' , true);
For get_product_meta;
$price = get_product_meta(83, 'price', true);
| Meta Key | Description |
|---|---|
| _wpsc_price | Product Price |
| _wpsc_special_price | Product Sales Price |
| _wpsc_sku | Product SKU |
| _wpsc_stock | empty if product does not use stock control, or stock quantity in not empty (so if it is 0 it means there is no stock left!) |
| _wpsc_currency | Serialized array of additional currencies and prices. |
| _wpsc_is_donation | Boolean Value, 0 if product is a standard product, 1 if the product is a donation. |
| _wpsc_product_metadata | Serialized Product Meta (used for data that does not get searched) see Table 3 |
_wpsc_product_metadata
This array can be retrieved using the same functions as the above product meta using get_post_meta and get_product_meta
| Key | Description |
|---|---|
| weight | Numeric weight amount |
| weight_unit | Weight Unit (pound, kilograms) |
| dimensions | Array of height, height_unit, width,width_unit, length, and length_unit |
| shipping | Per Product Shipping Amounts for Local and international |
| external_link | Product external link – used for redirecting users to different shop |
| external_link_text | Product external text – Text to replace Add to Cart for external products |
| external_link_target | Product external target – whether link should open in a new window, or on the same tab |
| merchant_notes | Notes for shop owners about the selected product |
| engraved | whether the product accepts personalized user inputted text. |
| can_have_uploaded_image | whether the product accepts personalized user images |
| enable_comments | Whether intenseDebate commenting is enabled for this product |
| unpublish_when_none_left | Checks whether or not to send notification email to store owner when stock runs out |
| no_shipping | Checks whether this product should disregard shipping |
| quantity_limited | Checks whether this product has limited quantity (__deprecated__) |
| special | Checks whether this product is marked as special (__deprecated__) |
| display_weight_as | Chosen display of weight in wp-admin |
| table_rate_price | A multiple array for quantity based pricing per product |
| google_prohibited | Set for products that are prohibited for sale on google |