Products

by admin, December 17, 2010

Add/Edit a Product

   <Back | ^Setup Home | Next>

Add a new product to your inventory, or change an existing one.

 

What’s New?

Jump To:

  1. To access the Products feature, move your mouse cursor to Inventory icon to choose from Products list on the Channergy Explorer.11
  2. You can search for a product by keying in text into the Product Number, Description,  or Long Description fields and click on the Search Button button.
    1. If  you check on the Real-Time Incremental Search check box the product search will happen real time.  NOTE: You can also set this feature to be the default behavior by selecting the check box in Tools -> Preferences under the Orders tab.
    2. The Full Text Search feature searches the Product Number, Description and Long Description fields for the text that you enter in that field and click on the Search Button button next to the full text search field.  NOTE: You can also set this field to be the default field when the search screen is opened by selecting the check box in Tools -> Preferences under the Orders tab.
    3. You can also filter the records in the grid by selecting the Supplier or the Product Type from the drop downs.
    4. Once you have found the product you are looking for,  you can either click on it in the grid view and click on the OK button or double click on the product.
    5. You can click on the New Product Button button and the software will create a new record in the Products table and close the search screen.
    6. Clicking on the Details Button will open up the selected product in a new products screen.
    7. If  you have Subproducts set  up in the software, click on the Subproducts tab tab.  This will show  you the following dialogThe grid view will show all of the products in  your database that are subproducts.
      1. To narrow your search select the Subproduct code from the drop down.subproductCodeBBLACKBERRY
      2. The available options dialog will be populated with the options that were set up when creating the subproducts. As  you select the available options from the drop downs, the grid details will filter the product listing until you have selected the options you want.  When you have located the product, click on the OK button to open the product.To search for an existing product click on the binocularsButtonicon or press Ctrl-F this will open the product search screen.
  3. To add a new product click on the New Buttonbutton.  This will create a new blank record in the products table.
    1. Product # – Enter up to 20 characters (numbers and/or text). This field is automatically capitalized so you can easily find the product later. You can also wand a bar code into this field.  This is the primary key for the products table you cannot enter in a duplicate product number.
    2. Name – Enter in a short name for the product this can be up to 100 characters in length.
    3. Description – Enter up to 255 characters to help you identify this product when viewing your inventory.
    4. Long Description – You can enter an unlimited length description of the item. This description can be viewed during order entry from the Product Lookup dialog when adding items to the order.
    5. Order Message – Enter up to a 50 character message that will be displayed when the product is selected during an order. It is a convenient way to add reminders to products (for example: “This item requires batteries.”).
    6. Supplier– Select a vendor from the Supplier field pull down list to associate the product with its supplier. If you have not added the supplier yet, you can make the association later by editing the product.
      1. If a supplier provides you with several products, enter the supplier first then, while in the Product Supply Vendor form, click the New Product button. Each product you add will be associated with that vendor.
      2. If you have multiple suppliers for the same product you can add them in the Suppliers tab.
    7. Product Type – Select a type if applicable, from the pulldown list, or create a new one with the Setup button. Product Types can be used in reports to group like items.
    8. Master Code – This field is used to associate a product with a sub-product.
    9. Option Text – This field is used for sending up the options to Channergy Web.
    10. Retail Price – This is the amount that will be charged to customers with a Pricing Level of Retail (or none) when taking an order. You may override this price on the order entry form for any item by simply typing the new price.
    11. Wholesale Price – This is the amount that will be charged to customers with a Pricing Level of Wholesale when taking an order. You may override this price on the order entry form for any item by simply typing the new price.
    12. Price 3 – This is the amount that will be charged to customers with a Pricing Level of Price 3 when taking an order. You may override this price on the order entry form for any item by simply typing the new price.
    13. Price 4 – This is the amount that will be charged to customers with a Pricing Level of Price 4 when taking an order. You may override this price on the order entry form for any item by simply typing the new price.
    14. By Quantity – Clicking on the Qty Button button next to the price fields opens the quantity discount screen. From this screen you can set quantity discounts for each price level.
    15. By Source Key – Click By Source Key button to set pricing that is used when a specific Ad Source Key is selected for an order.
      1. For each Source Key you may enter a Price that is charged for the item, and any Quantity Discounts you wish. This price will override any of the Retail, Wholesale, Price3 or Price4 prices already assigned to the product when the Source Key is selected during order entry.
    16. Mix & Match – Enter a code here in all the Product Numbers for which you wish to share a quantity discount. For example, you could enter MATCH into the Mix & Match field for products A, B and C and assign quantity discounts to them. If your first price break quantity is at 5 units then the customer could order 5 in any combination of these items to get the discount (e.g., 2 Product A, 1 Product B and 2 Product C = 5 units).
    17. Tax Exempt – Use this check box if  you want the product to be tax exempt.
    18. Minimum Advertised Price (MAP) – If your products have a MAP value then you can enter it here.
    19. Weight – Enter a weight for this item in pounds. Do not round weights to the nearest pound. You can use the weight calculator Weight Calculator to convert ounces to pounds.  Note: When the product is the master product of an assembly the software will add this value to the weight of each item in the assembly.
    20. Ship Extra Chg – Enter any additional shipping charge to the customer for this item (for example, oversized items). When a customer orders this product, the extra shipping charge will be added to the shipping field in addition to any other shipping charges.
    21. Ship Cost – Enter your cost to ship this item. This figure is used in reports that estimate your total shipping costs.
    22. Ships in Own Box – Indicates this item is to be shipped alone. This is a True/False field. You can specify in reports to display this information so your shipping personnel know to pack the item separately.
    23. Calculate Insurance – Channergy can calculate shipping insurance on individual items if applicable. Check this box to have this item included in the calculation. Note: You will also need to set the insurance calculation in Preferences under the Orders tab. Click the Special Items button then the Shipping Insurance tab.
      1. Check the Automatically calculate shipping insurance check box and enter a Rate ($ per $100 – .90 = 90 cents per 100 dollars). You also need to create a product in your inventory and select it in the Product Code pulldown. When you create the item enter a Retail price of $0.00 and check the Non Inventory checkbox on the Stock Levels tab.
        When a marked item is added to an order a line item will be added for shipping insurance using the rate and Product Code you specify.Note: Insurance will be charged at your Rate times the Subtotal of the order. If this value is less than your rate than the rate will be used (e.g. If your rate is $.90 per $100 and your order is less than $100 then $.90 will be added to the order).

Stock Levels
Enter quantities, stock types, reorder thresholds and costs.

  1. Find or Add a product as described above.
  2. Click the Stock Levels tab Stock Levels Tab
  3. The following screen will open.
  4. Non Inventory Item – Check this field if you do not track stock levels for this product. This will also prevent backorders during order entry.
    Tip: You can create other Non-Inventory items to add to orders (e.g., Discounts, Gift Certificates etc.).
  5. Drop Ship Item – Check this field if you do not stock this item, but have a third party ship it to your customer. You should also check the Non Inventory Item box unless you wish to maintain quantities for this product.
  6. Discontinued – Check this box to indicate the item is no longer available for sale. Orders will be allowed for the product until quantities reach zero (you should also check the Do not Allow Backorders checkbox to prevent backorders).
  7. Backorder Without Prompting – If checked when the item is ordered it will be marked as backordered without the dialog that prompts the operator to approve the backorder or force fill the item.
  8. Allow Substitution – When checked this item may be replaced by another item in inventory. Click the Settings button to select the item that will replace it and to specify if the substitution occurs when the item is out of stock and/or discontinued. You can also specify whether the operator will receive a notice that the substitution has taken place.
    Tip: This feature can also be used to create Aliases for a product if, for example, you offer a single product number that can be ordered under several different product numbers.
  9. In Stock – When creating a product, enter the current number of items you have on hand. Thereafter, In Stock quantities are calculated automatically by Channergy when you take orders, process refunds and Receive Inventory and Adjust InventoryNote: Also see the multiple locations field below.
  10. Details – Click the Details Button button to open the following dialog.It lists the counts of this product in various statuses on individual orders (e.g., The number Backordered).
    1. Committed – Shows the count of this item that have been ordered by customers and are currently in Committed (CM) status on individual orders. Committed items are removed from the available In Stock quantity.
    2. Backordered – Shows the count of this item currently backordered on individual orders. This count will not be deducted from the In Stock amount until you fill backorders.
    3. Filled – Shows the count of this item that have been invoiced on individual orders, but not yet shipped.
    4. Shipped – Shows the count of this item that have been shipped on individual orders.
    5. Returned – Shows the count of this item that have been returned on individual orders. Returned items are automatically returned to inventory.
    6. Canceled – Shows the count of this item that have been canceled on individual orders. Canceled items are automatically returned to inventory.
    7. Total – The total of all listed items in the dialog.
  11. Multiple Locations – Check this box to turn off the In Stock field and use separate locations for tracking of item quantities.
    1. To create locations click Setup on the Product screen then select Locations…
    2. In the dialog above enter as many different locations as you need. You may enter Warehouses, Bins etc. or any combination of these. You can also set the priority in the Preference field. Quantities in the first location will be depleted before each subsequent location.
    3. After setting up locations you can enter quantities in each by clicking the Locations button on the Product screen. Select the locations you created from the drop down and enter the number In Stock for each.
      1. Non-Inventory – You can set a location to be a non-inventory location.  An example of this would be a fulfillment warehouse or Amazon FBA.
      2. Drop Ship – If you select this option, a drop ship order will be created if this location is selected.
      3. Not Available For Sale – Select this option if you want to reserve items for returns or for building assemblies.
    4. Using Multiple Locations in Channergy guide can be found here.
  12. Customize – Click the 27 button in the Product tab to open a memo form you can use to add information to the product that can be viewed and edited during an order (by using the Customize button on the Item Detail tab on the Order Entry screen). This is especially useful for capturing descriptors like monograms, shipping instructions etc. Information typed in this memo form will print on invoices, work orders etc.
  13. Extras – Click the 25 button (under the “Stock Levels” tab) to open the following dialog
    1. Bin – This is the field where you can assign a bin location to the product.
    2. Custom Fields 1 – 5 – These fields can be used to store any additional information about your products.  Note: The field names can be changed in Tools->;Preferences under the Products tab.
    3. ISBN – Use this field for storing the ISBN for publications.   Data can be inserted into this field using a scanner and scanning the ISBN.
    4. UPC,UPC2 and UPC3 – Use these fields for storing UPC’s for products. Data can be inserted into these fields using a scanner and scanning the bar codes from the products.
    5. Manufacturer’s ID. – This is the original manufacturer’s product number (as opposed to the supplier’s number or your own).
    6. Supplier Product No. – This is your supplier’s product number for this item if it is different than yours. This number can be printed on purchase orders even if you create the PO with your product numbers.
    7. Supplier Description – This description can also appear on the PO to help your vendor identify the item you are ordering.
    8. Supplier Price – The price the supplier charges you for the item.
    9. Duty Percent – Enter a percent you, or the customer, expect to pay when shipping out of the country.
    10. Preferred Currency – Use the Setup text menu item on the Product screen to create your ISO Codes, then select the preferred currency code for this product here.
    11. Tarriff Code – A freeform field for any tariff codes that apply to this product.
    12. Royalty Item – Check to indicate that royalties are paid to a third party when this item is sold.
    13. Preferred Ship Method – Select any of the ship methods you have set up in your Shipping tables. This is the method this item should by shipped by.
    14. Max Ship Items – Then maximum number of items that may ship in a box.
    15. Backorder Message – This message appears on the order when this product is backordered.
    16. Unit of Measure – Use this field to define how this product is shipped for example each, gallon, doz, lb etc.
    17. ImageURLLarge – Use this to store the URL to the large image of the product.
    18. ImageURLSmall – Use this to store the URL to the small image of the product.
  14. VIN Number Required – Check this box to require that a Vehicle Identification Number be associated with this product before it is shipped. Channergy also includes a Vehicle Identification Number tracking system you can use to ensure Titles are received and sent to the customer.
  15. Serialized Inventory – Click on the Stock Levels tab from the Products screen as described above.
    1. Check the Serialize Inventory box if you want to track the serial numbers of individual products that you sell (cell phones, cameras etc).  When this option is checked, you will be prompted during Receive Inventory to scan in the serial numbers for those items.  Clicking the View button button will show you the Serial Numbers dialog box.
      This will list all of the serialized items for the selected product you have in stock, when they were received and who received them.
      1. These serial numbers are removed from the list when they are scanned during as part of the Box Scanning feature.
  16. Generate Gift Cert. – Check this box to create a product you can sell as a Gift Certificate. Channergy will create a unique random number and track its use. Customers can mail in certificates or use the number online. Certificates may be used all at once, or in multiple purchases.  Click the Settings Button button to open a dialog where you can specify how your certificate number is generated.
    You can specify a prefix, suffix, code length and whether the random number will contain numbers, letters or both. In the sample below a possible generated code could be: ABC54C1Q.
  17. On Channergy Web – If you use our ecommerce package, or if you export your products to your own system, check this box to indicate that this item is available for sale on the web.
  18. Subscription – If the product is a subscription item, check the check box.  To set up the item as a subscription item check the Subscription settings button the following dialog will be displayed.subscriptionSettings
    1. Frequency – This is how often this product is delivered, you can choose between Weekly, Annually,Monthly, or Days.
    2. Start Day – This is specifically for weekly subscriptions where 1 is for Monday, 2 is for Tuesday, etc.
    3. Duration – How many times this products is going to be shipped before it expires.  For instance a years subscription for a item that is delivered monthly will have a duration of 12.
    4. Automatic Renewal – Check this box if the subscription will automatically renew after it expires.  This will automatically generate another invoice for the customer when the subscription expires.
    5. Ship Product No- Use the drop down box to select the product that will be shipped with each order generated.
    6. Quantity – This is the number of the above products that are going to be shipped with each order.
  19. Preorder – Use this option if this product will be delivered at a later date.
    1. Ship Date – Use this field to set when the product is going to be delivered
    2. Message – Use this field to display a message in the order about the product
  20. Company Override – This feature allows specific products to be associated with specific companies select the company from the drop down menu.  Clicking the Company Setup Button button will open the Company Setup dialog box.
  21. Reorder At – Enter the quantity this item may reach before Channergy reminds you in report R4130 Products to Reorderto order more. You can also specify a Reorder Quantity and expected Reorder Price. These items will be entered automatically on Purchase Orders, but can be edited, when you order this product from your vendor.
    1. If your vendor has quantity discounts, click on the Supplier Quantity Discount button, this will open up the Quantity Discounts from Supplier dialog box.
    2. When a purchase order is made for a product that has quantity discounts the software will apply the discount to the purchase order.
  22. On Order and On Backorder quantities and dates are entered automatically by Purchase Orders when you create them. You can enter beginning amounts into these fields if applicable.
  23. Soft Allocated – Used for third party inventory management systems.
  24. Hard Allocated – Used for third party inventory management systems.
  25. Standard Cost – Enter a cost for this item. This amount will not change unless you edit it.
  26. Average Cost – Enter a beginning cost for this product. As you receive inventory Channergy calculates your average cost automatically and updates it here.

Create Assemblies

Create kits from individual items in your inventory.

Instructions
Assemblies are collections of various products in your inventory. You can create a product, for example – BLACKBERRY KIT, and add all the items from your inventory that make up the kit(charger, case, etc.). When you take an order you can select just the BLACKBERRY KIT and the other items will be added automatically.

  1. Add Component Products to be the parts of your assembly. For example, you can add a Blackberry, a Charger and a case, then assign these to an Master Assembly Product called Blackberry Kit.   Component products are created the same way as ordinary products (as described under the Add/Edit a Producthelp topic).
    1. Note: For each item you can optionally enter a Retail and/or a Wholesale price. These prices will be used when you sell the items separately. In the assembly prices for individual items will be added together to create a total price for your assembly based on the price level of the customer (e.g., a Retail customer will receive the sum of the retail prices).
      If you set prices for the Master Assembly Product they will be used in addition to the individual component prices. You can override individual component prices on the Master Assembly Product – details are below.
  2. Add a Master Assembly Product. After you have created the components of your assembly, you can create a master product that groups these items into a new product.
    1. On the Product tab enter a Product # that identifies the assembly (e.g., BLACKBERRY KIT). You can also enter a description, a long description etc. if you wish (as described under the Add/Edit a Product help topic).
    2. If you would like to set a price for the entire product enter it into the Retail Price and/or Wholesale fields. You can leave these blank if you prefer to have the price calculated based on the individual items in the assembly tab.
    3. Click the Stock Levels tab Stock Levels Tab
    4. Enter an In Stock amount or check the Non-Inventory Item check box if you do not need to keep track of quantities.
    5. Click the Assembly tab Assembly Tab A blank screen will appear where you can enter your previously created components.
    6. To add products to the assembly, start typing the Product Number or press F2 to launch the product search screen.
    7. Quantity – Enter the number of this item that are part of this assembly.
    8. Enter a Retail and/or Wholesale price if you wish. One of these amounts (depending on the customer’s type) will be added to the total price of the assembly. If you do not want the component price to be added to total enter a Zero (0.00). This will override the price on the separate component. If you enter zeroes for all the components only the price on the Master product will be charged.
    9. Discount – Enter a discount, if you wish, as a whole number (e.g., 10 = 10%). The discount will be applied to the price of the item. Typically you would not also enter a price in the step above. The price from the component product itself will be used and discounted.
    10. Continue adding parts to the assembly (you can use the Tab or Down Arrow keys on your keyboard to add additional items, or you can click the Add Button button). If you enter an item you do not need use the  Delete button to remove it.
    11. ADVANCED TIPS
      1. If you sell items separately and as part of an assembly you can enter the separate item prices on each product. Then, on the Assembly tab of the Master Assembly Product you can enter the discounted price you charge when they are part of the assembly, or enter a zero to just use the total price from the Master Assembly Product. You can also manually override any amount on the order itself.
      2. Each item of the assembly will print separately on the invoice and pick list report. You can use these to properly pull inventory and fill orders.
      3. If a part of assembly is out of stock it will be backordered automatically (although you can override the backorder). You may wish to manually backorder each of the other items as well with the Force Backorder option in the Item button.

Managing Multiple Suppliers

Instructions
You can associated multiple suppliers for all of your products through the Suppliers tab in the products screen.

  1. Click on the Suppliers tab Suppliers Tab
    1. The following screen will be displayed
    2. To add a new supplier for your product, click on the Plus Sign button at the bottom of the grid.  This will add a new blank row.
    3. In the new record click on the Supplier field and select the supplier from the Supplier Drop Down button.
    4. Tab through the fields and add them.
      1. Supplier Product #-This is the suppliers product number.  This will show up on the purchase order
      2. Supplier Price- The Suppliers Price.  This will show up on the purchase order.
      3. Unit of Measure – This is the optional unit of measure for the product.
      4. Min Qty- This is the optional minimum order quantity for this supplier.
      5. Breakdown-This is the optional breakdown quantity.
      6. Discount- Enter the optional discount percentage.
      7. Discount Amount– This is the optional discount currency amount.
      8. Manuracturer ID- This is the optional Manufacturers product number.
      9. Suppliers Description- Enter in the suppliers description of the product, this will show up on the purchase order
      10. Notes- This is an optional place to put notes.
    5. When you are done click on the Save Button button to save the record.
    6. If  you want to delete a supplier record select the record that you want to delete and click on the Delete Icon button.

Attachments

Instructions
You can associate files and pictures with all of your products through the Attachments tab in the products screen.

  1. Click on the Attachments tab Attachments Tab
    1. The following screen will be displayed
    2. To add a new attached file or image press on the Add Record button in the grid toolbar.  This will add another record to the grid.
    3. Tab through the fields to add information to the grid.
      1. File Name- This is the file name of the file/image you are attaching.  This is automatically populated when the file is attached.
      2. Description- This is an optional description of the item that you are attaching.
      3. Type- Select the type of file you are attaching from the drop down list, the choices are File or Picture
      4. Add File…- Click on the File Browser icon in the field this will open up a file dialog in the default directory similar toopenProducts
      5. Select the file you want to attach and click on the Open button.  When you have successfully attached a file your screen will look similar toattachmentsScreen
      6. You can click on the Open File Button button to view the file in its associated application.
      7. To add images the process is the same except you select Picture from the Type field and click on the Select File field in the Add Picture … field.  This will open the file dialog box with a filter for images.openProducts
      8. Click on the Open button and your attachment screen will look similar tosamplePhoto

Setting Up Channel Products

Instructions
The setup for each product channel varies for each channel.  However, before you can set up any product associations with your channels you have to set up the accounts through the Channel tab in the Tools -> Preferences screen.  However, for all channels you need to set up the following.  For more details click on the MCM documentation.

  1. Create an Operator ID for each channel.
  2. Set up the account login credentials in Tools -> Preferences Channels tab

For more details click on the MCM documentation.

  1. Amazon
    1. Click on the Amazon Tab Click Amazon Tab
    2. The Amazon channel screen will then show up.productsAmazonTab
    3. Select the Amazon account from the Account drop down list.
    4. Add the SKU.
      1. This is the Amazon Seller SKU.  In order for the orders downloading from Amazon this has to match exactly to the Seller SKU.  In other words, if the product on Amazon is called Abc123, it must be called Abc123 in the SKU field in this screen and not ABC123 or aBc123 or Abc-123.  The SKU’s are case sensitive.    If the Seller SKU is in ALL CAPS on your Seller Central Account then you can check the Use Channergy Prduct Number as SKU check box.
    5. Add the ASIN  this is the unique identifier that is created by Amazon.  If your products are unique on your Amazon store, in other words one ASIN for each product then you can run the Amazon product import as discussed in the MCM documentation.
    6. When you select a channel to assign a product to, Channergy assigns the retail price from the Product tab to the channel listing.  If you want to upload a different price to Amazon, uncheck the Use Current Retail Price and change the price in the Price field.
    7. The In Stock quantity defaults to the In Stock quantity from the Stock Levels tab.  If you want to upload a different quantity to Amazon, uncheck the Use Current In Stock Quantity field and change the stock quantity in the In Stock field.
    8. If the product is on sale check the On Sale Check Box box and add the Sale Price and set the start date and end date for the sale in the Sale Start Dt and Sale  End Dt fields.
    9. Sales Tax Code- This should be set to A_GEN_TAX
    10. Repricing Model ID- This field is used if you also have a ChannelMax account.
    11. Folder ID- This field is used for the product location within system.
    12. Leadtime to Ship-Select the number of days from the download. 
    13. Launch Date-Use this field to set when the product will be available for sale.  If it is left blank the product will be available immediately (as long as there is a quantity in stock).
    14. Allow gift message option- Select this check box if the product can include a gift message.
    15. Allow giftwrap option- Select this check box if the product includes an option to giftwrap.
    16. Amazon Fulfilled Item- Check this box if the product is fulfilled by Amazon.
    17. Condition-Use this drop down to select the  item condition.  The following table lists the conditions
      1. Used; Like New
      2. Used; Very Good
      3. Used; Good
      4. Used; Acceptable
      5. Collectible; Like New
      6. Collectible; Very Good
      7. Collectible; Good
      8. Collectible; Acceptable
      9. Used; Refurbished (for Electronics and Camera & Photo only)
      10. Refurbished (for Computers, Kitchen & Housewares, Electronics, and Camera & Photo only)
      11. New
    18. Item Note..- Click on the memoCustomizeButton  to add notes for used products.
    19. Click on the saveButton button to save the channel listing.
    20. Click on the addListingButton button to add a new listing for the same product.
    21. The makeActiveButton button toggles a product from InActive to active.
    22. The makeInactiveButton button toggles a product from Active to Inactive.
    23. The deleteListingButton marks the listing for deletion from Amazon.
      1. If you want to delete a listing from the grid, select the listing and press Ctrl-D or select File -> Delete.. from the text menu.
    24. The openInBrowserButton  will open the selected listing in a browser.
    25. After creating the listing your Amazon Channel tab will look similar to thistestAccountOne
  2. eBay
    1. Click on the eBay Tab Ebay Tab
    2. The eBay channel screen will show upproductsEbayTab
    3. Select the eBay account from the Account drop down list.
    4. Add the SKU.
      1. This is the Custom Field in the Ebay list.  In order for the orders downloading from eBay this has to match exactly to the Custom Field.  In other words, if the product on Custom Field is called Abc123, it must be called Abc123 in the SKU field in this screen and not ABC123 or aBc123 or Abc-123.  The SKU’s are case sensitive.    If the Custom Field is in ALL CAPS on your eBay Account then you can check the Use Channergy Prduct Number as SKU check box.
    5. The Category #, Price, In Stock, On Sale, and Sale Price are currently not used and are reserved for when eBay product upload a is available.
    6. Click on the saveButton  button to save the channel listing.
    7. Click on the addListingButton  button to add a new listing for the same product.
    8. The makeActiveButton  button toggles a product from Inactive to active.
    9. The makeInactiveButton  button toggles a product from Active to Inactive.
    10. The deleteListingButton marks the listing for deletion from the channel.
      1. If you want to delete a listing from the grid, select the listing and press Ctrl-D or select File -> Delete.. from the text menu.
  3. Fulfillment By Amazon (FBA)
    1. Click on the Fulfillment By Amazon Tab FBA Tab
    2. The Amazon Fulfillment By Amazon channel screen will then show up.productsAmazonFullfillmentTab
    3. Select the Fulfillment By Amazon account from the Account drop down list.
    4. Add the SKU.
      1. This is the Amazon Seller SKU.  In order for the orders downloading from Amazon this has to match exactly to the Seller SKU.  In other words, if the product on Amazon is called Abc123, it must be called Abc123 in the SKU field in this screen and not ABC123 or aBc123 or Abc-123.  The SKU’s are case sensitive.    If the Seller SKU is in ALL CAPS on your Seller Central Account then you can check the Use Channergy Prduct Number as SKU check box.
    5. Click on the saveButton  button to save the channel listing.
    6. Click on the addListingButton  button to add a new listing for the same product.
    7. ThemakeActiveButton   button toggles a product from Inactive to active.
    8. The makeInactiveButton  button toggles a product from Active to Inactive.
    9. ThedeleteListingButton  marks the listing for deletion from the channel.
      1. If you want to delete a listing from the grid, select the listing and press Ctrl-D or select File -> Delete.. from the text menu.
  4. Buy.com
    1. Click on the Buy.com tab Buy.com Tab
    2. The Buy.com screen will show up.productsBuyDotComTab
    3. Select the Buy.com channel account from the Account drop down list.
    4. Add the Reference ID.
      1. This is the same Reference ID that is used to identify your product in your Buy.com account.  In order for the orders downloading from Buy.com this has to match exactly to the Reference ID.  In other words, if the product on Buy.com is called Abc123, it must be called Abc123 in the reference ID field in this screen and not ABC123 or aBc123 or Abc-123.  The Reference ID’s are case sensitive.    If the Reference ID  is in ALL CAPS on your Buy.com Account then you can check the Use Channergy Prduct Number as SKU check box.
    5. Add the UPC for the Product.
      1. Note: This is required for inventory updates.
    6. Click on the saveButton  button to save the channel listing.
    7. Click on the addListingButton  button to add a new listing for the same product.
    8. The makeActiveButton  button toggles a product from Inactive to active.
    9. The makeInactiveButton  button toggles a product from Active to Inactive.
    10. The deleteListingButton marks the listing for deletion from the channel.
      1. If you want to delete a listing from the grid, select the listing and press Ctrl-D or select File -> Delete.. from the text menu.
    11. The UPC, Price, Leadtime to Ship, Condition and Description are currently not used and are reserved for when Buy.com product upload a is available.
  5. Volusion
    1. Click on the Volusion tab Volusion Tab
    2. The Buy.com screen will show up.productsVolusionTab
    3. Select the Volusion account from the Account drop down list.
    4. Add the SKU.
      1. This is the same SKU that is used to identify your product in your Volusion store.  In order for the orders downloading from your Volusion store this has to match exactly to the SKU in this field.  In other words, if the product on your Volusion store is called Abc123, it must be called Abc123 in the SKU field in this screen and not ABC123 or aBc123 or Abc-123.  The SKU’s are case sensitive.    If the SKU in your Volusion store  is in ALL CAPS then you can check the Use Channergy Prduct Number as SKU check box.
    5. Category #- This is a required field for  uploading the product to the Volusion store.  To determine what category number to use check your Volusion administrative panel.
    6. Price – When adding a new channel listing Channergy defaults to using the current retail price.  If you want Volusion to upload a different price, uncheck the Use Current Retail Price check box and edit the price field.
    7. In Stock- Enter in the stock quantity that you want to upload to your Volusion store.  If you always want to upload the Channergy in stock quantity to Volusion check the Use Current In Stock Quantity
    8. On Sale- Check this box if you want to offer a sale price on the product.
    9. Sale Price- If you select the On Sale check box add the sale price into this field.
    10. Click on the saveButton  button to save the channel listing.
    11. Click on the addListingButton  button to add a new listing for the same product.
    12. The makeActiveButton  button toggles a product from Inactive to active.
    13. The makeInactiveButton  button toggles a product from Active to Inactive.
    14. The deleteListingButton marks the listing for deletion from the channel.
      1. If you want to delete a listing from the grid, select the listing and press Ctrl-D or select File -> Delete.. from the text menu.
  6. Other SQL Based Channels
    1. Below are general setup instructions for the other channels not mentioned in this document.  As of Build 1116 these instructions apply to the following carts.
      1. Magento
      2. OS Commerce
      3. X-Cart
      4. Zen Cart
      5. Custom (MySQL)
      6. Custom (SQL Server)
    2. Select the channel tab that you will be adding the product to Custom MySQL
    3. This will show the following screen.productsCustomMySQLTab
    4. Select the channel account you are adding the product to from the Account drop down.
    5. Add the SKU, this is the Product that you want to upload to the cart, it is also the alias for orders that are downloaded from the cart.  This is case sensitive, so you must match exactly what will be downloaded if this product is ordered.  In other words, if the product on the cart is called Abc123, the SKU field must show Abc123 and not ABC123 (the default Channergy product number) .  If you are adding a new product to the store, then select the Use Channergy Produt Number as SKU
    6. Category #- This is the category number that this product will be associated with on the store.  To determine this value depends on the channel and the specific implementation of the channel.
    7. Price – When adding a new channel listing Channergy defaults to using the current retail price.  If you want the channel to upload a different price, uncheck the Use Current Retail Price check box and edit the price field.
    8. In Stock- Enter in the stock quantity that you want to upload to your store.  If you always want to upload the Channergy in stock quantity to the channel check the Use Current In Stock Quantity
    9. On Sale- Check this box if you want to offer a sale price on the product.
    10. Sale Price- If you select the On Sale check box add the sale price into this field.
    11. Click on the saveButton  button to save the channel listing.
    12. Click on the addListingButton  button to add a new listing for the same product.
    13. The makeActiveButton  button toggles a product from Inactive to active.
    14. The makeInactiveButton  button toggles a product from Active to Inactive.
    15. The deleteListingButton marks the listing for deletion from the channel.
      1. If you want to delete a listing from the grid, select the listing and press Ctrl-D or select File -> Delete.. from the text menu.
    16. NOTES: Most of this type of store (channel) support full implementation of the MCM.  This means, downloading orders, uploading tracking numbers (shipping confirmation) and product upload.  However, there are some carts that do not support all three data transfers.  Below are some known issues with specific carts
      1. X-Cart-Due to the complex nature of the database schema used in X-Cart, it is not possible to do a full product upload.  What Channergy can do is update existing products (prices, in stock quantities) but cannot add new products.

UNDER THE HOOD: As is the case with any inventory management system, the Products table is at the center of it operations.  The Products table interacts directly with the following tables Discounts, Supplier, ProdType, LocStock,Location, Subscription, Assembly, ProductSuppliers, ProductAttachments and ChannelListings.  It is important to note that with your installation of Channergy, not all of these tables will have data in them.

When you click on the New product button, the software creates a blank record in the Products table.  The product number is entered and Channergy will capitalize what is entered into the Product # field.  It is important to understand that this field is the primary key in the table and if you key in a product number that is already in Channergy it will through an error message.  The supplier drop down is populated with a list of the suppliers from the suppliers table.  When you select a supplier from the list the associated SupplierNo is added to the SupplierNo field in the Products table.   The Product Type drop down is populated with the Description field from the ProdType table.   When, the product type is selected, the associated ProductCode is added to the ProdType field in the Product table.  If you have subproducts set up in Channergy, the Master Code dropdown is populated with a list of all of the distinct MasterCodes from the SubProducts table.  When a MasterCode is selected that value is populated in the Serial field of the products table.

Quantity pricing is handled in the Discounts table.  Depending on what type of discount pricing you select, Retail, Wholesale, Price3, Price4, By Source Key or Reorder Price , the data are put into the table in the following manner.  When a new record is added to the Discounts table, a new record is added to the table and the DiscountNo field is populated with the next number in the sequence, the ProductNo is pulled from the current record in the Products table and the PriceLevel is populated with the type of price level (Retail,Wholesale, Price3,Price4, Source Cod, or Reorder Pr); the From Qty, To Qty and Unit Price fields are populated from the Discounts dialog box for volume discounts and the Source Key,  is populated from the Ads table.

Item substitutions are added to the SubstProductNo,SubstProductNo2, SubstOrductNo3 fields in the Products table.

When an Assembly (Kit) is created a record is added to the with the ProductNo of the master product is added to the ProductNo field in the Assembly table.    When an assembly item is selected from the Product No list in the interface that productNo is added to the AddProductNo field in the Assembly table.  If the price fields are left blank the software will use the retail prices for each individual product in the Kit in addition to the master kit price.  If you want the Kit price to be just the Master product price set the price fields to zero.

When multiple suppliers are used the ProductNo for the current product is added to the ProductNo field in the ProductSuppliers table.  The SupplierNo is populated from the drop down list in the interface showing a list of the Suppliers in the system.  The ProductSuppliersNo is an autoincrementing field.  The remaining values in the Suppliers tab correspond to the fields in the ProductSuppliers table.

If files are attached to a product the data regarding the attached files are stored in the ProductAttachments table.  The actual data is stored in the Attachments/Products folder.  When a file is attached to a product the ProductNo is added to the ProductNo field in the ProductAttachments table, in addition the Description, Type fields are updated from the corresponding fields in the Attachments tab.   After the file is selected the file name is added to the FileName field in the ProductAttachments table.

When a product is added to a channel the ChannelListings table is populated in the following manner.  The ChannelNo field is populated  with the ChannelNo from the Channels table.  As of Build 1116 the following channel numbers are assigned.

1    Amazon
2    eBay
3    X-Cart
4    Zen Cart
5    Custom (MySQL)
6    Custom (SQL Server)
7    Half.com *
8    osCommerce
9    Magento
10    Volusion
11    Buy.com
12    Yahoo! *
13    Channergy Web *
14    Fulfillment By Amazon
15    ChannelMAX
16    Shopify *
17    Just Add Commerce
18    Custom FTP *
19    T-HUB *

* Channel not currently implemented

The ChannelAccountNo is pulled from the ChannelAccounts table based on the Account selected from the Account drop down list in the Channel.  The ProductNo is populated from the selected product.  The SKU, Price, IsCurrentRetailPrice,IsOnSale,SalePrice,SaleStartDt,SaleEndDt,UPC,EAN,ISBN,ASIN,IsActive,IsRemove,IsDelete, LaunchDt,LeadtimeToShipDays,IsGiftwrapAvailable,IsGiftMessageAvailable,IsProductNoAsSKU, CategoryNo,InStock, IsFulFillmentByAmazon, ItemCondition, ItemNote, RepricingModelId, TaxCode, and RepricingFolderID are all populated from the Channel tab depending on what channel is selected.  Other fields in the ChannelListings table are either not currently used or, used for process tracking.

 <Back | ^Setup Home | Next>

No Comments


Please login to comment