Note that you should only use this page if CyberShop is not used in conjunction with CyberBuild. Otherwise, use the "Add Remove Catalog Items" menu instead.

This page lets you edit the details of a product in the inventory database. CyberShop presents a default set of fields that under most circumstances are enough to cover a generic kind of products. But you are free to add new fields to the underlying table (named "Stock_Table") in the shopping cart database (or the catalog database if specified under Global/System Settings).

To display the real-time product item on your shopping page, insert the following script (anywhere in your HTML page):

<script src="view_product.asp?ProductID=myproduct"></script>

where myproduct is the product reference code. Be sure to qualify "view_product.asp" with the appropriate domain and path. CyberShop lets you customize the view_product.asp page if you are not satisfied with the default layout or wants to introduce custom fields etc. ASP programming knowledge is required. The default does give you simple choice of using your own images etc.

Wildcard Listing: It is possible to display a selected set of products using just one script. In this case,  myproduct can be a prefix of the set of the products. For example setting ProductID=ABC will display products "ABC001", "ABC002", ...

By default, this feature is disabled. To turn it on, simply edit the view_product.asp page (under notepad) to set, on top of the page,

Session(DSN+"ExactMatch") = False

Two special products: "-search-" and "-viewcart-" can be used to display a "Search Box" to search for the products in the inventory and to view the shopping cart contents. You can insert the following two codes on your shopping pages to display the information,

<script src="view_product.asp?ProductID=-search-"></script>
<script src="view_product.asp?ProductID=-viewcart-"></script>

It is not necessary (though convenient) to use the two scripts. You can simply come up with your own design for the Search and the View Cart buttons.

The primary function of this page is to let you edit the product details using a browser-based interface.  You may edit it off-line by exporting the data to you local disk on the "Inventory Manager" page. Then import it back to the system.

Find Product:  Type in a ProductID (or Reference) into the first box, then click this button to find the first match. Wildcard is appended to the end of the reference when searching for products.

Add/Update:  Update the changes to the system after editing.

Delete Item:  Remove the entry from the database.

Reset Form:  (on the bottom of the page) Restore the original information.

Default Fields

Reference: The product ID or the Reference Code that identifies the product / item in question.

Stock: The stock level of the product.

Warning: The warning level for the stock of the product. When stock drops below this level, a warning message is sent with the order information to the merchant(s).

Minimum: The minimum level for the stock of the product. When stock drops below this level, CyberShop will stop the product from being ordered.

Type: The product type of the product. Identical to the meaning of the Item Types defined under the Shop Manager and the ProductType information that is passed on to the shopping cart from a shopping page. This is used in shipping fee calculation.

Description: The description of the product. Typically limited to 100 characters.

Cost: The cost of the product.

Price: The sale price of the product. When set, CyberShop will verify the price passed from a shopping page to the shopping cart. This will detect any discrepancy in the prices thus stop the false price from being added to the shopping cart.

Tax Rate: Tax Rate for the product, used only if you are doing an import/export business. Otherwise, leave it empty.

Small Image: The file name of a small image for the product. If the image is not under the shopping cart directory, an absolute URL, starting with "/" or "http://" is preferred. Though it is possible to define an alternative default image path on the view_product.asp and search.asp pages (edit them using Notepad).

By default, Small Image is displayed on the Search page (search.asp).

Large Image:  The file name of a large image for the product. By default, it is displayed by the view_product.asp page.

Keywords: Define the keywords or phrases that you like your customers to find the products. By default, the "Search" page will search this field plus the "Description" and "Reference" fields to find any matches. Limited to 100 characters.

Product Information: Any additional information you may have about the product. This field has no length limit.

Quantity: Specify the default quantity that a customer will order. Obviously, he/she will be able to change it.

Base Quantity: This is a hidden field that is used to tell the shopping cart how many components are in the product. These components should be treated as individual items when the shipping fee is calculated. For example, you would like to set it to 6 if the item is a 6 CD pack of a well-known artist. Base Quantity sometimes indicates the weight of the product (typically in lb. or kg). See Shipping Fee Manager for more discussions.

Coupon Code: This is a hidden field that will pass the coupon information to the shopping cart for discount. The customer still needs to click on the "Discount" button on the shopping cart to activate it. But this saves you from telling every customer what is the code (when it is on sale).

Point: The frequent buyer's points required to redeem the product, not set or setting it to zero will disable it from being redeemed by points. Frequent buyer's reward is a feature of CyberOffice Club (a companion product of CyberShop).

Bonus: Bonus points if a customer bought this product. Credited into his/her membership account. Again, works with CyberOffice Club.

Dest Email: This field is generally not set. If set the order information will be forwarded to this email address, in addition to the one that is specified under Global/System Settings.

Page URL: The URL of the page that will display the current product. If you leave it empty, CyberShop will automatically index it when the page is called on your site. Make sure you enter an absolute URL starting with "/".

Taxable: Either either Yes or No to specify if the item is subject to "State Tax", "Country Tax" or "GST". The default is "Yes".

Delivery Mode: This is related to the Delivery Schedule where customers can specify the time slot for the delivery or service of the item. Leave it empty or set it to 0 if the function is not applicable. It can take either 1 or -1 as the possible values. "1" indicates that the item must be delivered or serviced on its own. One item takes up one slot (can have multiple quantities though). "-1" means that the item can share the slot with others. Namely, if all the items having "-1" as the Delivery Mode can be delivered at the same time.

Remark: Any internal remarks for the product.

Discount Price Field(s)

You can create a built-in volume discount price field by specifying the threshold quantity and then click on the "Create" button next to it. After that, you will enter the "Unit Price" for customers who orders over the discount quantity on the product. Any number of discount levels can be created.

QuickBooks Fields

Three fields, Sales Account, Inventory Account, and COGS Account are for QuickBooks bookkeeping usage. So you can share the Inventory database with QuickBooks (via the File Import/Export functions on the Inventory Manager).