Update Products to be Available on the Web

Keep both the Acctivate product list and the shopping cart products up to date by exporting and/or importing a list of products available on the web in Acctivate. Since only products marked as Available on Web will be included in the product export we have lined out steps below to update the items to have this specification.

6-3-2016 2-03-23 PM

Setup an Excel Query to Extract Product List

  1. Follow the instructions in the Excel query article to step 4
  2. Select the proper Acctivate database
  3. Choose the Product view
    Product View
  4. Click Next
  5. Give the file a Name, File Location, Description, Friendly, Name, and Search Keywords (all optional)
  6. Click Finish
  7. The Import Data window will appear for you to select how you want to view this data in your workbook and where you want to put it. Select the proper option for you (Table is typical)
  8. Click OK when finished and the Product view will populate the Excel sheet
  9. Update the AvailOnWeb column to be TRUE for any item which needs to have this specification

Import Excel Query Data to Update Products to be Available on Web

  1. Using the spreadsheet created above, follow the instructions listed here until Mapping Editor [2/5] step 6
  2. Map the Product ID and Available on Web columns
  3. Save Mapping
  4. Begin Import
  5. Follow the prompts until the import completes (detailed instructions in article linked in Step 1)

Once the import completes, any product marked as Available on Web will be exported using the Export Product List utility.

Posted in Import Data, Web Store Integration - Last modified on August 18, 2016Lauren Stine
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.