WCS SQL Cheat Sheet

Posted by Hariharan Vadivelu on

I have compiled together a list of frequently used WCS SQL's by subsystem's
Please do leave a comment if you have some useful snippet that you would like to share with the community, I will update the corresponding GIST frequently to keep the list up to date.



19 comments:

  1. Hi Hair,

    I need your help. Past 2 year I am working in WCS. Now I have a chance to work in atg. I am confused I have to continue on WCS or I have to take atg opportunity. Which one will be good for future. Which one is having more onsite opportunities

    ReplyDelete
  2. Very helpful your all kind of post to create the perfect ecommerce websites for online sales business.Each and every post having the great development tutoria.
    Website Designing Bangalore | Web Designing Company Bangalore

    ReplyDelete
  3. Hello I read your blog it is great and useful for us , Thanks for share this blog. we are providing Gambir Sarawak feedback ,Gambir Sarawak feedback, Gambir Sarawak, Gambir Sarawak liquid, Gambir Sarawak side effect in USA. If you want to know more about this services please visit website.

    ReplyDelete
  4. Thank you so much for the post

    ReplyDelete
  5. I am not able to find the SQL cheatsheet could you please repost the same.
    Thanks.

    ReplyDelete
  6. I am not able to find the SQL cheatsheet could you please repost the same.
    Thanks.

    ReplyDelete
  7. Working with Microsoft Access designing a new database, the question here is what is the core process of the database that you are trying to define? Access Database design is more of an art than a science and common sense will prevail. See more sql query commands cheat sheet

    ReplyDelete
  8. It was very nice blog to learn about SAP BASIS. Thanks for sharing.SAP basis

    ReplyDelete
  9. Hi folks,
    I'm working on promotion related stuff in WCS 7. I just want to create a promotion with following condition :

    The customer could make a single purchase of 1, 2 or 3 pants and receive 25% off of each of the items. If the customer tries to purchase additional quantity of pants, they would not receive the discount. Additionally, if the customer only purchased 2 pants and then added another set to the cart, the discount would not be applied.

    Or like


    Will OOB support this functionality? For e.g., Get 10% off on product X, maximum upto 5
    quantities. Can you please help me?

    I just want to limit the customer to apply the promotion for single order of maximum 5 qty. If he applied promotion for cart with 3 item in an order and for second order he should not allowed to apply same promotion for even 1 qty.

    I’ve tried up with following data set up to achieve the requirement ,

    #1
    Maximum redemption for this Promotion = Unlimited
    Maximum redemption on single order = 5
    Maximum redemption by a single customer =5

    For this setup, I’m able to apply promotion for second order for same Customer. (So, this Promo setup is failed)

    #2
    Maximum redemption for this Promotion = Unlimited
    Maximum redemption on single order = 5
    Maximum redemption by a single customer =1

    For this setup,
    I’m unable to apply promotion for more than one qty in a single order for single customer(if the order has 5 qty). (So, this Promo setup is failed)

    #3
    Maximum redemption for this Promotion = Unlimited
    Maximum redemption on single order = 1
    Maximum redemption by a single customer =5

    For this setup, I’m able to apply promotion for second order for same Customer. (So, this Promo setup is failed).

    I have checked with OOB machine also, both are behaving similarly.

    Promotion type : percentage off individual catentry promotion.

    Could you please help me in this regard.
    If you need further details please let me know.

    Thanks in advance !

    ReplyDelete
  10. I am a regular user of your post, this one also was very interesting and well written. keep sharing the great work
    Web development company in bangalore
    Outsource magento ecommerce services india
    ECommerce Website developers in bangalore

    ReplyDelete
  11. Eblon Enterprises are the Best Digital Marketing Company in India having its base at Delhi NCR. Eblon Enterprises has dedicated and excellent management and expert team of Digital Marketing. Our Company Offer SEO services, SMM, PPC and more. Call +91-9911358120.

    Digital Marketing Company In India

    ReplyDelete
  12. Eblon Enterprises offers the best website design & development services and affordable internet marketing services in Delhi and in India for online business needs. Get professional web development & design services at very low cost.
    Designing Development Service In India

    ReplyDelete
  13. We are a Web Designing Company in Delhi, India. We are centrally located in Delhi Zone of Delhi in India. We offer website design, web development.
    http://eblonenterprises.com/website-designing-services-in-delhi-ncr/

    ReplyDelete