AUI Service Infrastructure

Components

Component

Description

Ref

<<Config Service>>

Configuration details used for Service, S3 to SQS lambda

osp-product-import-file-service

<<S3 Bucket>>

S3 Bucket to store file uploaded by the user

AWS S3 Bucket

<<SQS>>

SQS to store the product in sqs for further processing

AWS SQS

<<SQS>>

SQS to store the product availability details in sqs for further processing

AWS SQS

<<SQS>>

SQS to store the product capping details in sqs for further processing

AWS SQS

<<SQS>>

SQS to store the product checkout details in sqs for further processing

AWS SQS

<<SQS>>

SQS to store the priority one mesages in sqs for further processing

AWS SQS

<<SQS>>

SQS to store the priority two mesages in sqs for further processing

AWS SQS

<<RDS>>

RDS to save product information

storepick-aui.product-table

<<RDS>>

RDS to save audit information for MIN to check who uploaded data

AWS RDS

<<RDS>>

RDS to save user role information

AWS RDS

<<RDS>>

RDS to save product capping information for MIN

storepick-aui.product_caping

<<RDS>>

RDS to save file upload or to store the table payload

AWS RDS

<<RDS>>

RDS to save product masking information for MIN

AWS RDS

<<RDS>>

RDS to save order details

AWS RDS

<<Ecstask>>

This service is used to comunicate Availability UI Portal. This service have various endpoint to GET/POST/PUT/DELETE data

storepick-aui-productavailaibility-Ecs

Configuration(from config service)

Config File Name

storepick-aui-productavailability-service.json

Value:

Attribute

Description

S3_BUCKET_NAME

S3 bucket to upload product import, capping, masking files for process and some predefined templates also

S3_PRODUCT_IMPORT_PATH

Import path for product import file

PRODUCT_SQS_NAME

Product SQS name in this file-processor lambdas will add MINs from uploaded file into batches

SQS_MSG_LIMIT

This is SQS message limit to add number of MINs in one message

FILE_TYPES

Supported file types csv and xlsx

PRODUCT_DYNAMODB_TABLE

This dynamoDB table will save product information

PRODUCT_CAP_DYNAMODB_TABLE

This dynamoDB table will save product capping information

PRODUCT_MASKING_DYNAMODB_TABLE

This dynamoDB table will save product masking information

BULK_UPLOAD_DYNAMODB_TABLE

This dynamoDB table will save file upload and single MIN upload status

AUDIT_DYNAMODB_TABLE

This dynamoDB table will use to save audit information like who uploaded/updated product and what time

USER_ROLE_DYNAMODB_TABLE

This dynamoDB table will use to save userid and role information

ORDERS_DYNAMODB_TABLE

This dynamoDB table will use to save orders information

MORI_BASE_URL

This is morrisons base URL

PRODUCT_URL

This is product service URL

OSP_BASE_URL

This is OCADO base URL

OSP_AVAILABILITY_URL

This is OCADO availability URL to GET/POST product overrides

AWS S3 Bucket

Environment

S3 Bucket

dev

mdev.xxwmm.storepick.aui.product-import.eeeeeeeeee

sit

msit.xxwmm.storepick.aui.product-import.eeeeeeeeee

prd

mprd.xxwmm.storepick.aui.product-import.zzzzzzzzzz

AWS SQS

Environment

SQS

dev

sqs-euw1-dev-storepick-aui-product-import-002.fifo

sit

sqs-euw1-sit-storepick-aui-product-import-002.fifo

prd

sqs-euw1-prd-storepick-aui-product-import-002.fifo

AWS SQS

Environment

SQS

dev

sqs-euw1-dev-storepick-aui-product-availability-002.fifo

sit

sqs-euw1-sit-storepick-aui-product-availability-002.fifo

prd

sqs-euw1-prd-storepick-aui-product-availability-002.fifo

AWS SQS

Environment

SQS

dev

sqs-euw1-dev-storepick-aui-product-checkout-002.fifo

sit

sqs-euw1-sit-storepick-aui-product-checkout-002.fifo

prd

sqs-euw1-prd-storepick-aui-product-checkout-002.fifo

AWS SQS

Environment

SQS

dev

sqs-euw1-dev-storepick-aui-product-capping-002.fifo

sit

sqs-euw1-sit-storepick-aui-product-capping-002.fifo

prd

sqs-euw1-prd-storepick-aui-product-capping-002.fifo

AWS SQS

Environment

SQS

dev

sqs-euw1-dev-storepick-aui-oos-priority-one-002.fifo

sit

sqs-euw1-sit-storepick-aui-oos-priority-one-002.fifo

prd

sqs-euw1-prd-storepick-aui-oos-priority-one-002.fifo

AWS SQS

Environment

SQS

dev

sqs-euw1-dev-storepick-aui-oos-priority-two-002.fifo

sit

sqs-euw1-sit-storepick-aui-oos-priority-two-002.fifo

prd

sqs-euw1-prd-storepick-aui-oos-priority-two-002.fifo

AWS RDS

Environment

RDS

dev

dev.xxwmm.storepick.aui.products

sit

sit.xxwmm.storepick.aui.products

prd

prd.xxwmm.storepick.aui.products

AWS RDS

Environment

RDS

dev

dev.xxwmm.storepick.aui.bulk_upload

sit

sit.xxwmm.storepick.aui.bulk_upload

prd

prd.xxwmm.storepick.aui.bulk_upload

AWS Ecs

Environment

Ecs

dev

ec2-euw1-n-digital-vpc001-commonEcs-001

sit

ec2-euw1-n-digital-vpc001-commonEcs-001

prd

ec2-euw1-n-digital-vpc001-commonEcs-001

AWS RDS

Environment

RDS

dev

dev.xxwmm.storepick.aui.user_roles

sit

sit.xxwmm.storepick.aui.user_roles

prd

prd.xxwmm.storepick.aui.user_roles

AWS RDS

Environment

RDS

dev

dev.xxwmm.storepick.aui.orders

sit

sit.xxwmm.storepick.aui.orders

prd

prd.xxwmm.storepick.aui.orders

AWS RDS

Environment

RDS

dev

dev.xxwmm.storepick.aui.audit

sit

sit.xxwmm.storepick.aui.audit

prd

prd.xxwmm.storepick.aui.audit

AWS RDS

Environment

RDS

dev

dev.xxwmm.storepick.aui.product_masking

sit

sit.xxwmm.storepick.aui.product_masking

prd

prd.xxwmm.storepick.aui.product_masking