Base de connaissances

In the global update area, you can make changes to many products at one time, thus saving time. Note that global updates change many products at once, and it is easy to make changes you don't want. Be sure to back up your database before proceeding.

Global Sale Price Updates:

Select a category to update. All items within that category will be updated. Then, enter the following:

• Before proceeding, it is highly recommended to make a backup of your site and save it onto your computer.
• "Set To:" Enter the value you wish to update to.
• Set the factors you wish to use to set the sale prices. You can choose:Select "Update Sale Price" to process the sale prices.
  • Percent off the regular price - this takes a set percent off the price value, provided the percent is under 100. For instance, if you have entered "15" into the "Set To:" field, this will take 15% off the regular price on every item in the category.
  • Amount off the regular price - this takes a set amount off the price value, provided the amount is less than the price value. For instance, if you have entered "2.25" into the "Set To:" field, this will subtract 2.25 from the regular price on every item in the category that is greater than 2.25.
  • Exact amount - this sets the sale price to exactly what you enter in the "Set To:" field. For instance, if you have entered "8.50" into the "Set To:" field, this will set the sale price value to 8.50 for every item in the category.
  • Remove sale prices - this sets the sale price to zero for every item in the category.

Global Deletes:

Use this area to delete all items in a particular category or to delete all items in your catalog.

CAUTION!!! Use great care when using this feature, as it will permanently remove all items!

• Before proceeding, it is highly recommended to make a backup of your site and save it onto your computer.
• Select Category: Select a category you would like to delete from, or choose "Delete All Products" to delete all items from your catalog.
• Only Delete: To limit your deletes further, select the items you wish to delete. You can select all items, out of stock items, items with no inventory, only sale items, only inactive items, or only items marked as wholesale only.
• Select "Delete" to process the deletes.

Upload Files:

If you have many products in your store and wish to load items via a spreadsheet or text file, you can use this area to load the file.

• Before proceeding, it is highly recommended to make a backup of your site and save it onto your computer.
• Create a tab delimited text file that contains all the products you wish to upload. This sheet should contain:After the sheet has been created, use the "Browse" button to find the sheet on your computer.
  • A "header row" with the following headers, in the exact order specified, separated by a tab (instead of a comma as shown here): 
    Catalog, Item, Description, MetaTitle, Keywords, SmImage, LgImage, SmImage2, LgImage2, SmImage3, LgImage3, SmImage4, LgImage4, SmImage5, LgImage5, SmImage6, LgImage6, SmImage7, LgImage7, SmImage8, LgImage8, SmImage9, LgImage9, SmImage10, LgImage10, SmImage11, LgImage11, SmImage12, LgImage12, Category1, Category2, Category3, Category4, Category5, Category6, Category7, Category8, Category9, Category10, Category11, Category 12, Category13, Category14, Category15, Units, RegPrice, SalePrice, ItemCost, Wholesale, TaxPercent, Featured, WSOnly, OutOfStock, Active, DateEdited
  • Add your products, separating all fields by tabs. Use the same column format as above, and leave fields blank if you do not have any data for a field.
  • For best results, use the sample sheet provided as a guideline.
  • It is recommended that you load only a hundred or so items at one time if possible - possibly only one main category at a time - to decrease the possibility of error. That way, if you make a mistake, it is easy to delete products in that category and begin again.
  • The "Catalog" field, which contains the catalog number or part number, is the row identifier. This means that if a product in your text file has the same catalog number as another item already in your database, that item will be updated. If there is no item already in the database with that catalog number, the product will be added.
• Choose whether you wish to update options for these products. Checking this box will create options for each product you upload that are exactly like the options that the default product has. For instance, if the default product has an option "Size", with choices "Small, Medium, Large", and a second option "Color", with choices "Red, Blue, Yellow", if you check this box, all items that you upload will also have these exact same options added.
• Select "Upload Sheet" to load the text file.