Is there an automatic way of determining New Products?

You can configure NitroSell eCommerce to select all products created in the past X Days.

For example, to mark any item created in the last 60 days as being a New Product on the WebStore, perform the following steps :

  1. In NSc Sync Configuration, under Advanced, select Field Mappings.

  2. Under Item, right-click product_newproduct.

  3. Select Properties, then click Advanced.

  4. Change the Field Source for product_newproduct to:

    CASE WHEN DATECREATED > GETDATE()-60 THEN 1 ELSE 0 END

  5. Click Validate, then click OK.

  6. Synchronize.

To check which products are new on your webstore see:

http://www.your-store-url.com/advsearch.asp?submitted=1&product_newproduct=1

or

http://www.your-store-url.com/store/more.asp?page=whatsnew

See also Displaying PAM Promotional Items on Separate Pages.

2 Likes

Two questions:

  1. Can the field source be for the date the product was added to the website (it can sometimes take a few weeks from when they come into store to be photographed etc)?
  2. Can product filter search be added to the whatsnew page?

Thanks,

Chris

Hey Chris,

  1. Yes! As long as the date is recorded in a field, we can use that. It’s common to use the Release Date field in PAM for this purpose. If that sounds like it’d work, we can dig out the appropriate field mapping for you.

  2. Not currently but we can certainly add it as a suggestion for the next filtered search refresh.

Regards,
Donogh

@donogh when I copy your instructions exactly, I get an error: image

Hi Patrick,

These mappings are not designed for our Cash Register Express edition – they’re for our RMS edition.

@peter_szczepanowski could you guys assist Patrick, please?

Kind regards,
Donogh

Hi Patrick,

This is what the mapping should look like:

CASE WHEN inventory.DATE_CREATED > GETDATE()-60 THEN 1 ELSE 0 END

Luckily there is a very slight difference in the naming convention between RMS and CRE in this case.

Regards,

Peter