⚙️ Settings

Manage Products and Cities Lists

📝 Instructions:

Products Format: Product Name,Price Qty1,Price Qty2,Price Qty3,Price Qty4,Price Qty5,Price Qty6

Example: تحاميل العنبر,100,200,300,400,500,600

• Enter each product on a separate line with prices for quantities 1-6

• Cities: Enter each city on a separate line

• Empty lines will be ignored

• Data will be saved to text files: products.txt and cities.txt

📦 Products List

Format: Product Name,Price1,Price2,Price3,Price4,Price5,Price6,Domain (one product per line)
Example: علاج حساسية الجهاز التنفسي,129,200,270,350,400,450,www.enresie.com
Note: Domain is required for WhatsApp mode orders (orders will be saved to that domain's orders.json)

🏙️ Cities List

Each city should be on a separate line

🚚 Delivery Sheet

Enter the Google Sheet ID for delivery tracking
Enter the name of the sheet tab (e.g., "Orders", "Delivery")
Enter the deployed Google Apps Script URL for delivery sheet 
function doPost(e) {
  try {
    const sheetId = e.parameter.sheet_id || '';
    const sheetName = e.parameter.sheet_name || '';
    const orderId = e.parameter.order_id || '';
    const date = e.parameter.date || '';
    const clientName = e.parameter.client_name || '';
    const phone = e.parameter.phone || '';
    const productInfo = e.parameter.product_info || '';
    const price = e.parameter.price || '';
    const city = e.parameter.city || '';
    const address = e.parameter.address || '';
    const status = e.parameter.status || 'Waiting';

    if (!sheetId || !sheetName) {
      return ContentService
        .createTextOutput(JSON.stringify({success: false, error: 'Sheet ID and Sheet Name are required'}))
        .setMimeType(ContentService.MimeType.JSON);
    }

    const spreadsheet = SpreadsheetApp.openById(sheetId);
    let sheet = null;

    // Get or create sheet by name
    try {
      sheet = spreadsheet.getSheetByName(sheetName);
      if (!sheet) {
        sheet = spreadsheet.insertSheet(sheetName);
      }
    } catch (error) {
      sheet = spreadsheet.insertSheet(sheetName);
    }

    const lastRow = sheet.getLastRow();

    if (lastRow === 0) {
      // Set headers if sheet is empty
      sheet.getRange(1, 1).setValue('ID');
      sheet.getRange(1, 2).setValue('Date');
      sheet.getRange(1, 4).setValue('Client');
      sheet.getRange(1, 5).setValue('Phone');
      sheet.getRange(1, 6).setValue('Product');
      sheet.getRange(1, 7).setValue('Price');
      sheet.getRange(1, 8).setValue('City');
      sheet.getRange(1, 9).setValue('Address');
      sheet.getRange(1, 11).setValue('Status');
    }

    // Append new data row
    const newRow = lastRow === 0 ? 2 : lastRow + 1;
    sheet.getRange(newRow, 1).setValue(orderId); // Column A
    sheet.getRange(newRow, 2).setValue(date); // Column B
    sheet.getRange(newRow, 4).setValue(clientName); // Column D
    sheet.getRange(newRow, 5).setValue(phone); // Column E
    sheet.getRange(newRow, 6).setValue(productInfo); // Column F
    sheet.getRange(newRow, 7).setValue(price); // Column G (as value)
    sheet.getRange(newRow, 8).setValue(city); // Column H
    sheet.getRange(newRow, 9).setValue(address); // Column I
    sheet.getRange(newRow, 11).setValue(status); // Column K

    return ContentService
      .createTextOutput(JSON.stringify({success: true}))
      .setMimeType(ContentService.MimeType.JSON);

  } catch (error) {
    return ContentService
      .createTextOutput(JSON.stringify({success: false, error: error.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}
Instructions:
1. Go to Google Apps Script
2. Create a new project
3. Copy and paste the code above
4. Save the project
5. Click "Deploy" → "New deployment"
6. Select "Web app" as type
7. Set "Execute as" to "Me" and "Who has access" to "Anyone"
8. Copy the deployment URL and paste it above