How can I speed up the process of updating our product data?

Submit the same file format for each update:

Our content engineering team writes a unique program that is customized to your data. Part of what this program does is map your columns to our existing specifications. When you change your file significantly, the team has to go back and update or re-write your program. This can cause delays.

Let us know what changes to expect:

Write a quick note with your file submission to let us know what changes to expect.  Did you change your column headers? Add a column with Gene ID's? Delete 2,000 products? Add 4,000 products? Are you writing over old catalog numbers with new data? Knowing what to expect with your file will tell us exactly what to look for during upload and QA. This will both speed up our QA process and insure that the changes you intended are reflected on the site.

Field specifications in separate columns:

For example, if you are still providing the antibody target as part of the product name (and not as a separate column), then delays can be expected. Not only is there extra programming involved, but often times we need to resort to manual efforts to extract each target.

Categorize your products:

In separate spreadsheets of an Excel workbook (or if that is not feasible, in a separate column) separate your products by broad category, or indicate which broad category your product belongs to. A significant amount of our time is spent training our programs to recognize and categorize your product types. Having this data will help to speed up your file processing. Here are the broad categories to choose from:

• Accessories
• Animals
• Antibodies
• Assay Kit
• Biomolecule
• Cells & Strains
• Chemicals & Reagents
• Chromatography & Separation
• DNA
• Equipment

• Equipment Accessories
• RNA
• Services
• Software
• Supplies & Consumables
• Tissues
• Lysates & Extracts

Click here for the permanent link to this question.