eCommerce Software

Shopping Cart Software and Complete E-Commerce Solutions

Languages English
CALL: 302.724.4517
divider

Introducing the ampleShop Data Management Tools

Contents

  1. Import Tool
  2. Database Export Tools
  3. Batch Operations
  4. Installation Instructions and Update Notes

1. Import tool

The ampleShop™ Import Tool allows the store administrator to upload a CSV file and import values into the ampleShop™  Products table.  CSV values are associated with the fields in ampleShop's Products, ProductMatrix and Media tables.

  1. For update operations you can replace default values with the selected CSV information or substitute a custom default value. The product records are filtered by the SKU column during the product update operation.
  2. For insert operations, if no CSV columns are specified, default values are used

The following behaviors can be specified during data import:

  1. Data
    1. Only Update Existing Products 
    2. Insert New Products and Update Existing Ones
    3. Insert New Products Only
    4. Delete All Products and then Import New Products
  2. On Error
    1. Skip Rows and Continue Inserting (error log will be displayed)
    2. Stop Importing and Undo Changes 
  3. Enforce Referential Integrity Check on Foreign Key Columns 
    1. Yes
    2. No

2. Database Export Tools

The database export tools allow the user to either export the Table Data or only the Table Structure.  Exports are done using Microsoft Excel or CSV format.

The following tables can be specified for export:

  1. Products
  2. Categories
  3. Product Attributes 
  4. Related Product Groups
  5. Suppliers
  6. Discounts
  7. Countries
  8. Customers
  9. Orders

3. Batch Operations

  1. Purge Old Data
    1. Abandoned Shopping Cart Items 
    2. Product Statistics History 
    3. Website Statistics History
    4. Admin Logs
    5. Customer Logs 
    6. Client Logs
  2. Products
    1. Apply Product Discounts 
    2. Modify Product Price 
    3. Activate/Deactivate Products 
  3. Countries
    1. Enable/Disable Countries 
  4. Statistics
    1. Run Product Ranking Script
    2. Rerun Product Statistics
    3. Reset Product Statistics

4. Installation Instructions and Update  Notes

The following files were affected during the database Tools development:

File name Description
admin/includes/css/css.csvAdded 5 new Styles
admin/menufiles/products.cfmBroken link updated
admin/menufiles/site.cfmBroken link updated
admin/images/alert_large.gifAdded new image
components/public/Query.cfcAdded CheckFKRecord function
components/public/Query.cfcFunction GetProductAttributes SQL change added new argument allProductAttributes
components/public/Query.cfcFunction GetCustomerAddresses added conditional statement for passing of the customerID argument
components/public/Statistics.cfcFunction RankProducts - added request.ThisStoreID filter on the GetProducts database query.
admin/products/Product_RecordAction.cfmEncapsulated the product deletion routine by placing it in the DeleteProduct.cfm file.
admin/products/Products_RecordEdit.cfmSKU form field is now required.

The following files were added:

File name Description
admin/batches/BatchModifyTable.cfmCollects user input
admin/batches/BatchOperations.cfmDisplays available batch operations
admin/batches/BatchPurges.cfmCollects date range input for purges and executes the actions.
admin/batches/ColumnList.cfmCustom Tag by David Shadovitz. Creates a "properly" ordered list of columns in a query.
admin/batches/csv_2_recordset.cfmCustom Tag that loops through a CSV file and creates a recordset.
admin/batches/csvSettings.cfmEncapsulates settings used in the custom tag.
admin/batches/DataMining.cfmDisplays form with file upload functionality.
admin/batches/DumpData.cfm
Custom Tag by Tom Muck. Dynamically outputs the passed recordset.
admin/batches/ExportAction.cfmExports table structure or data and structure in CSV or Excel format
admin/batches/ExportData.cfmDisplays available export tables
admin/batches/ImportAction.cfmExecutes the Data Import
admin/batches/PreviewData.cfmDisplays dynamically produced recordset to the user before running the import operation.
admin/batches/ProductDatabaseConfig.cfmDisplays form fields with the available Product table import columns along with CSV table columns and default import value form fields.
admin/batches/RunStatistics.cfmRuns the Statistics batch operations.
admin/products/DeleteProduct.cfmDeletes specified products from the database.


Bug Update 1
07.02.2006 Activating and Deactivating Product
Notes: After deactivating products they could not be retrieved thought the product drill and there was not an easy way to reactivate them.
The following files were affected by this update

File name Description
admin/products/Products_RecordView.cfmAdded 'Active' table header
admin/includes/RecordDrill.cfmAdded 'Show inactive' checkbox option
admin/includes/SetFieldsToVariabes.cfmAdded conditional logic for ShowInactive form field.
admin/includes/AdvancedSearch.cfmAdopted the generated SQL statement to include the pr.Active table field.
components/public/Query.cfcGetProducts function now returns Product Active status.

Bug Update 2
02.02.2006 Add New Administrator Bug fix.
Affected files: admin/Application.cfm
Notes: After the Statistics Tools update some users reported bugs while inserting new administrators. Error was located in the line where we invoke the Administrator Log object. The bug we fixed by adding the not IsDefined("form.AsignedCategories") statement in the condition.

The following files were affected

File name Description
admin/Application.cfmAdded

Processor Update 3
08.02.2006 QuickCommerPro gateway update
Merchants processing transactions using trans.cgi OR ats.cgi WILL NEED TO MIGRATE TO OUR NEW process.cgi BY FEBRUARY 28TH, 2006. For detailed information about who is required to migrate, please refer to our migration site at https://www.quickcommerce.com/migration.taf .

Notes: We have modified the productionUrl attribute of the gateway node in the XML that stores the processor settings file. While passing test transactions we noticed that the old gateway listener file failed while processing the new gateway response and we adjusted the query_string loop to reorder the results returned by QuickCommercePro.
 
The following files were affected


File name 		Description
dbbatch/paymentProcessors.xmlUpdated the QuickCommercePro gateway
templates/default/gatewayResponseList.cfmModified the query_string loop.

Please do not forget to update the gatewayResponseList.cfm file the site root of every store.

Update 4
08.02.2006 PayPal Bug Fix
Notes: Several users reported that we have mistyped the PayPal testing URL.

The following files were affected

File name Description
components/private/PayPal.cfmSet 'https://www.sandbox.paypal.com/cgi-bin/webscr' as a test URL.

To install just unpack the contents of the zip folder in the ampleShop™ root folder.