Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Working with CRM's/Databases to manage Real Time Data

CRM Databases Software Support JAVA PHP AUTOMATION Javascript Logic Software Development Coding

  • Please log in to reply

#1
Upilster

Upilster

    New Member

  • Member
  • Pip
  • 3 posts

Hi guys, I have a query,

 

Need help figuring out best algorithm / Process for the below scenario:

 

I am trying to create a small process:

 

(A)  I have 10 different Suppliers; I sell Hats on their Behalf.

 

1)    5 of my Suppliers produce hats themselves and sell through other online shops. They rely on traditional methods to manage, so no systems available.

 

Information has to be manually keyed in through a secure page, which connects to my DB.

 

2)    With my other 5 Suppliers, we have setup an automated feed, so I can directly access their DB/CRM, which is connected directly to my DB.

 

As a result, I am able to track down any real time data and product availability.

 

(B)  Database, with stored product data.

 

©  Output: UI page to display Available hats and product information to Buying Customers.

 

Issue to figure out…

 

To help improve customer service and ensure Buying Customers are viewing correct merchandize information:

 

I need help on figuring out on…

 

a)    How will I be able to ensure information currently held within my DB is kept up-to-date on a frequent basis from 5 of my Suppliers from point A1)…?  

 

As they cannot afford to purchase systems, they are currently manually keying in their information and selling through other online shops. Therefore, making things much more difficult to keep track of.  

 

Please Note:

 

Need to avoid sending constant emails & Alerts as reminders to update on stock.

 

Only time they will receive constant emails or alerts, is when a customer has made a purchase or request!

 

Overall aim is to make sure that a Buying Customer is purchasing stock that is only Available to buy from Suppliers.

 

 

What is the best process or solution?

 

Overview:

 

Screenshot 2015-04-09 22.15.40.png

 

https://www.dropbox.....15.40.png?dl=0


  • 0

Advertisements







Similar Topics


Also tagged with one or more of these keywords: CRM, Databases, Software Support, JAVA, PHP, AUTOMATION, Javascript, Logic, Software Development, Coding

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP