SwissChecklist

Checklist: BUDev - Run Kuechenhelfer Product Import (nopCommerce)

Import Products from Movanorm and their Excel Sheets
  • Prepare Product Price-List

    Show Details Show Substeps Show Substeps Show Substeps
  • Populate price lists in Excel with price formulas

    Show Details Show Substeps Show Substeps Show Substeps
    Product and Price Lists
    • Raw data are delivered by Movanorm
    • First about 10 colums are calculated by 2sic, for each Manufacturer
  • Get ok from Movanorm (Adrian Stocker)

    Show Details Show Substeps Show Substeps Show Substeps
  • Prepare Excel-Lists for Import to SQL Server

    Show Details Show Substeps Show Substeps Show Substeps
    • Add a dummy-row on top with very long TEXT3 (e.g. 2'000 characters)!
    • Change "Number Type" of EANNR from "General" to "Number"
    • Do special Sorting for:
      • Miele: ARTNR Z-A
      • V-Zug: ARTNR Z-A
      • Wesco: EDVNR Z-A
    • V-Zug - Adapt Column Types:
      • EDVNR: Text
      • EANNR: Number
  • Import Excel Price Lists to SQL Server

    Show Details Show Substeps Show Substeps Show Substeps

    If you get errors like: Cannot insert the value NULL into column 'ARTNR', table 'KuechenHelfer Products.dbo.Prices Miele'; column does not allow nulls. INSERT fails.
    > Ensure the first row contains an ARTNR with Text, like XKM2100KM, but not a number like 7070070!
  • Prepare Descriptions and Product-Mappings

    Show Details Show Substeps Show Substeps Show Substeps
  • Download product descriptions from Manufacturer Sites

    Show Details Show Substeps Show Substeps Show Substeps
    Update ProductDescriptionsSources SQL Tabel first in DWH

    irobot Program, iRobot File

    Before your run
    • Validate Detail-Action results in an expected Variable (e.g. ProductName is resolved correctly)

    For Bosch
    • Irobot seems to reach it's a memory Limit. To Work around, split the Source Data (ProductDescriptionsSources Table) into two Groups/Workloads

    For V-Zug
    • Also run GetVZugFrmEDVNR
  • Normalize product descriptions (PowerShell script)

    Show Details Show Substeps Show Substeps Show Substeps
    Normalize Product Descriptions
  • Assign products to manufacturer URLs (Product Mappings ***.xlsx Files)

    Show Details Show Substeps Show Substeps Show Substeps
    • Excel-Sheets at Product Mappings (e.g. Product Mappings AEG.xlsx)
    • Assign all Products from the Worksheet Missing Mappings
    • Ensure all new Products have a Value in Description Category (otherwise the Product Description wasn't downloaded)
    • If Descriptions are old or not yet download, run UpdateOldDescriptions in iRobot
  • Validate Manufacturer Mappings (validate Categories from Movanorm with Categories from Maunfacturer Website, especially for V-Zug)

    Show Details Show Substeps Show Substeps Show Substeps
    Maybe the EDVNR has changed and is now used for a different Product (happended for V-Zug a few times). Ensure our Backofen has a Description of Category Backofen etc.
  • Import Excel product mappings

    Show Details Show Substeps Show Substeps Show Substeps
    run Import Product Mappings to SQL Server.sql
  • Optional: Do automatic ToppreiseID-Assignment (irobot on external Computer)

    Show Details Show Substeps Show Substeps Show Substeps
    Prepare Automatic Matches

    Run Automatic Matches
    • open Remote Desktop "Srv-WebScrap-01"
    • ensure VPN/Proxy is connected
    • Open AutoMatches.irb
    • Run Task GetToppreiseMappings

    Post-Process Automatic Matches
    • run Access Macro Sync Matches and Queue again
    • Open Product-Mappings again
    • assign the ToppreiseIDs (using Auto-Matches)
    • Import Product-Mappings to SQL-Server
  • Prepare Images

    Show Details Show Substeps Show Substeps Show Substeps
  • Shrink very large images

    Show Details Show Substeps Show Substeps Show Substeps
    open \\Srv-Web-62.2siccloud.local\Projects\Kuechenhelfer\Product Images\

    Batch-Resize using IrfanView:
    • Important: Ensure you keep PNGs as them (Batch convert JPGs and PNGs separately)
    • Target Size: "Set long side to: 800 pixels"

    Known large files
    • V-Zug: Choose Files > 500 KB
    • Siemens: Choose Files wider/heigher than 800 px (might be all files)
  • Optional: Download Product Images from Toppreise

    Show Details Show Substeps Show Substeps Show Substeps
    To see the list of Images which would get downloaded, open the following PowerShell and comment out the line starting with "Download-ToppreiseImage ..."

  • Optional: Process Toppreise Images

    Show Details Show Substeps Show Substeps Show Substeps
    Validate there are no Pictures showing "sorry, no picture"! Check all Folders like Bosch\Toppreise, delete obviously wrong images

    Remove white borders
    • Open IrfanView
    • Do a Batch Conversion
      • Source: e.g. Bauknecht\Toppreise (only choose images created today)
      • Target: \Optimized
      • Options:
        • Crop: no
        • Resize: no
        • Auto Crop borders: yes
  • Import Data

    Show Details Show Substeps Show Substeps Show Substeps
  • Run Import in DWH

    Show Details Show Substeps Show Substeps Show Substeps
    Execute Stored Procedure [nopSync]
  • Clear Cache in nopCommerce

    Show Details Show Substeps Show Substeps Show Substeps
  • Rebuild Search Index

    Show Details Show Substeps Show Substeps Show Substeps
    Open Lucene.net full text support, click Rebuild Index at the bottom
  • Test/Validate

    Show Details Show Substeps Show Substeps Show Substeps
  • Test some of the changed products on the Online-Shop (Website)

    Show Details Show Substeps Show Substeps Show Substeps
  • Analyze Prices - especially inform Adrian/2da about too high Special Prices

    Show Details Show Substeps Show Substeps Show Substeps
    ToDo

    Sample
    S:\Projects\KuechenHelfer\Content\Products\2016-04-15 Preisanalyse.xlsx
  • New Step

    Show Details Show Substeps Show Substeps Show Substeps
Use this Checklist

Preview/Print

Use

Change

Sort